#1
|
|||
|
|||
Unhide and Re-hide in Excel 2003
I have the following problem: I have hidden quite a lot of rows (containing formulas). Now I want to copy an entire column with Copy-paste Special so they only contain values. This means I first have to unhide all the rows, and then hide them again. But is there a possibility to hide whatever was hidden with one easy click? Or do you I have to write down the numbers of all the rows that were hidden in the first place, and then select them all again to hide them again? |
#2
|
||||
|
||||
Unhide
Select and copy data Use the 'Undo' button to hide all that you unhid Paste previously copied data |
Tags |
excel, hidden, hide, unhide |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to transfer Word 2003 Tables to Excel? | steeleye | Word Tables | 1 | 07-10-2009 04:18 PM |
Hide a combo box | DrewB | Word | 3 | 06-08-2009 11:29 PM |
How to hide HYPERLINK meta tags in Word. | bhargav.suku | Word | 5 | 05-14-2009 11:11 PM |
Excel 2003 - Different Header for each page | franklyorange | Excel | 0 | 08-26-2008 02:26 PM |
Conditional Formatting to Hide Rows or Columns? | sczegus | Excel | 0 | 09-26-2006 04:17 PM |