| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
How do I reduce the columns outside my data?
I'm using Excel 2007 and somehow the worksheet created columns to the right
of my data that affects my horizontal scroll bar. All data is deleted but the scroll bar won't revert back to the utilized area of the worksheet. |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
How do I reduce the columns outside my data?
Look he
http://www.contextures.com/xlfaqApp.html#Unused -- Kind regards, Niek Otten Microsoft MVP - Excel "JFort" wrote in message ... I'm using Excel 2007 and somehow the worksheet created columns to the right of my data that affects my horizontal scroll bar. All data is deleted but the scroll bar won't revert back to the utilized area of the worksheet. |
|
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
How do I reduce the columns outside my data?
After deleting the columns you must save the workbook to reset the range.
Do not just "clear contents". Gord Dibben MS Excel MVP On Mon, 14 Sep 2009 13:00:01 -0700, JFort wrote: I'm using Excel 2007 and somehow the worksheet created columns to the right of my data that affects my horizontal scroll bar. All data is deleted but the scroll bar won't revert back to the utilized area of the worksheet. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reduce excel file size by deleting blank rows and columns?? | Excel Discussion (Misc queries) | |||
| I want to actually reduce the number of rows & columns in a worksh | Excel Discussion (Misc queries) | |||
| How do I reduce the amount of columns in a sheet? | Excel Discussion (Misc queries) | |||
| How do I reduce the no. of rows & columns in a worksheet ? | Excel Discussion (Misc queries) | |||
| Reduce columns and rows count? | Excel Worksheet Functions | |||
Linear Mode
