Hi,
let's say that you hide rows 4 and 5, so in your spreadsheet you see rows 3
and then 6, highlight first row and last row after the hidden ones, right
click on the mouse unhide

if this helps please click yes, thanks

"barbardn" wrote:

Can someone help? This is the first time I have asked for help. I am new to
Excel and have just developed a spreadsheet that adds up several columns for
me. I have, it seems, applied the correct formula to work out different
percentages in several columns for me. I am quite pleased with myself.

I had to delete several rows from the spreadsheet but I selected "Hide"
instead of "delete" on the rows that I wanted to remove!

I realise now that the text has been hidden away but the total still
includes the figures in that row! How can I reveal the rows that I have
hidden away to enable me to delete them from the final calculation?

--
Nanny Barb - Retired