Excel Spreadsheets - hidden rows

  • Thread starter Thread starter barbardn
  • Start date Start date
B

barbardn

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?
 
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
 
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+(
 
Back
Top