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
|