Excel Spreadsheets - hidden rows
 

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

Excel Spreadsheets - hidden rows
 

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

Excel Spreadsheets - hidden rows
 

Have you tried this?:
http://spreadsheets.about.com/od/exc...4unhiderow.htm

Excel Spreadsheets - hidden rows
 

Hi,

If you don't want any rows hidden click the top left corner of the sheet
(between the row numbers and column letters) and press Ctrl+Shift+(

If you just want to unhide certain rows highlight across those rows (say
A3:A10 when A4:A9 are hidden) and press Ctrl+Shift+(

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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