| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Viewing information after hiding columns / rows
No easy way as far as I know but you could hold the Ctrl key and select the
columns you want and then paste them into the new sheet. This will paste the columns together with out the missing columns -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Annie" wrote: Hi If I hide a column or row and then copy and paste the remaining data how can I just show that data on a new sheet without the hidden information. Many thanks -- Kind regards Ann Shaw |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying information from rows to columns | Excel Discussion (Misc queries) | |||
| hiding columns or rows not using the hide function | Excel Worksheet Functions | |||
| Looking up information based on Columns and Rows | Excel Worksheet Functions | |||
| hiding/unhiding rows & columns with "+" and "-" buttons | Excel Discussion (Misc queries) | |||
| Hiding of rows and columns | Excel Discussion (Misc queries) | |||
Threaded Mode
