• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Tables: How to make worksheet a table without printing it all

B

BigD

Member
My subject did not explain what I am trying to do too well. I will attempt again:

When I turn my worksheet into a table, excel is wanting to print 23,000+ pages. How do I make the whole worksheet a table so the user does not have to insert rows without Excel wanting to print the entire thing (even empty cells).....I hope this makes sense. I am struggling describing this, lol - sorry.

Thank you for your time.
 
BigD said:
My subject did not explain what I am trying to do too well. I will attempt again:

When I turn my worksheet into a table, excel is wanting to print 23,000+ pages. How do I make the whole worksheet a table so the user does not have to insert rows without Excel wanting to print the entire thing (even empty cells).....I hope this makes sense. I am struggling describing this, lol - sorry.

Thank you for your time.
Click to expand...
Hi,

If I understand correctly you've selected all the cells on a worksheet and on the insert tab you've clicked 'Table'. If I got that right then as you say if someone clicks Print then it will print the entire worksheet amounting to tens of thousands of pages.

I really can't see any advantage in doing this but if you must then what you could do is print a selection. i.e select what you want to print and within the print wizard select 'Selection'
 
You do not turn all the worksheet into a table, just the raw data, including functions and formulas, by selecting the whole worksheet you are taking up a huge amount of memory and resourse for a worksheet with very little in it, this is because Excel thinks you will , at some time, be adding all your conditions to the sheet cells and as such reserves what it thinks it needs in resourses.
When you turn your data into a table and the user reaches the last bottom right hand cell, excel will, when they press the tab key, add a new row with all conditions. If the user goes to the right of an existing table to enter data Excel will start a new column with all conditions you have set.

.
 
"excel will, when they press the tab key, add a new row with all conditions."

This what I was curious of and was not aware of.

Thank you both for taking the time to reply!
 
You must log in or register to reply here.
Back
Top