Get rid of error message: "Can not shift objects off sheet"?

J

Jennie

It appears my worksheet may be getting a little too long in Excel - though
I'm only using columns A through HQ at present. Need to be able to finish
out the year - with one column per day. Any chance of that happening? How
do I get Excel to give me more room and ability to hide columns by subtotal
columns as I please without getting this error message?
 
S

StumpedAgain

There are only 256 columns in excel. If you plan on using one each day
you're going to fall short (unless you're doing business days - 251). Unless
you're planning on deleting some columns or combining columns, you're out of
luck. Even when hiding columns, it doesn't give you more columns to work
from. My suggestion would to to flip-flop your database and use rows for
dates.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

'Cannot shift objects off sheet' error message (group/outline) 2
"Cannot shift objects off sheet" error when trying to hide a colum 2
"cannot shift objects off sheet" error 8
gettin an error "Cannot shift objects off sheet" while filtering 1
Cannot Shift objects off sheet. 1
Cannot shift objects off sheet? 2
"Cannot shift objects off sheet" when grouping or hiding 2
Error message "Cannot shift objects off sheet" 1

Top