|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 14th, 2009, 09:00 PM
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
September 15th, 2009, 10:19 AM
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
September 15th, 2009, 06:32 PM
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
