Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Spreadsheets - hidden rows
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
opening a group but keep hidden rows hidden | Excel Discussion (Misc queries) | |||
Hidden rows columns won't stay hidden | Excel Worksheet Functions | |||
Formula or Code to keep Hidden Rows Hidden | Excel Worksheet Functions | |||
I need my Hidden Rows to stay hidden when I print the sheet. | Excel Discussion (Misc queries) | |||
Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) |