| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I stop an Excel sheet from automatically hiding rows when .
When I open an Excel worksheet, several rows of data are automatically
hidden. How can I change this? It's annoying |
|
#2
|
|||
|
|||
|
Hi
I'm guessing there's some code running that's doing this. After you've opened your workbook, right mouse click on a sheet tab, and choose view code. On the left hand side of the VBE window (under where you see your workbook's name in bold) you'll see ThisWorkbook - double click on it and some code should come up on the right ... i'm guessing your problem is in there. Cheers JulieD "kazyreed" wrote in message ... When I open an Excel worksheet, several rows of data are automatically hidden. How can I change this? It's annoying |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can you add more rows in excel 2000? | Excel Discussion (Misc queries) | |||
| Excel converts Mapped drive to UNC - How to stop? | Links and Linking in Excel | |||
| in excel, how do i set up a spread sheet that automatically total. | New Users to Excel | |||
| how to let excel ask to save the sheet when closing the excel file | Setting up and Configuration of Excel | |||
| Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel | |||
Linear Mode
