| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
column width
I have a spreadsheets with many columns. since the columns are too wide, I
am changing the column width to 4. Everything seemed to be OK, but now it doesn't let me do it. It says "cannot shift objects off sheet" I have many empty columns at the end of the sheet, and when I tried deleting them, nothing happened. -- newyorkjoy thanks for the help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
column width
newyorkjoy wrote:
I have a spreadsheets with many columns. since the columns are too wide, I am changing the column width to 4. Everything seemed to be OK, but now it doesn't let me do it. It says "cannot shift objects off sheet" I have many empty columns at the end of the sheet, and when I tried deleting them, nothing happened. Have you tried reselecting your print area? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200703/1 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
column width
Maybe...
XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns http://support.microsoft.com/default...b;en-ca;211769 Remember to look for comments and merged cells. newyorkjoy wrote: I have a spreadsheets with many columns. since the columns are too wide, I am changing the column width to 4. Everything seemed to be OK, but now it doesn't let me do it. It says "cannot shift objects off sheet" I have many empty columns at the end of the sheet, and when I tried deleting them, nothing happened. -- newyorkjoy thanks for the help! -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
column width
If you have any cell formatting in the "empty" cells, Excel will see those
and count those cells. Example: If you added a border around each cell, but didn't hilite the area you wanted borders on, it will "see" borders even in the blank cells. -- Hazel "newyorkjoy" wrote: I have a spreadsheets with many columns. since the columns are too wide, I am changing the column width to 4. Everything seemed to be OK, but now it doesn't let me do it. It says "cannot shift objects off sheet" I have many empty columns at the end of the sheet, and when I tried deleting them, nothing happened. -- newyorkjoy thanks for the help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I create multiple column width in the same column in excel | Excel Discussion (Misc queries) | |||
| How to make cell width different than the column width it lies in | Excel Discussion (Misc queries) | |||
| Column width | Excel Discussion (Misc queries) | |||
| Varying column width in a column chart | Charts and Charting in Excel | |||
| Change the width of a single column in a column chart | Charts and Charting in Excel | |||
Linear Mode
