How do you limit rows and columns in an excel worksheet?
- 1 Answers
- 784 Views
- I also Faced
- E-Mail Answers
Answer / Dileep Kumar Singh
To set limits on the number of rows or columns, go to File > Page Setup > Sheet. In the Print Area section, select the cells you want to keep visible, then click on 'Set Print Area'. You can also use the Max Rows and Max Columns properties in the VBA editor to limit the workbook's overall size.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is excel and when would I use it?
Can a pivot table use multiple sources of data?
What is a spreadsheet made up of?
How do I make one page landscape in excel?
How do you conduct a scenario analysis?
Who is the founder of ms excel?
How do I change numbers to #value in excel?
What is the use of split cells option in computer?
Search for: can excel be a database?
How do I fill a sheet name with color in excel?
How do I open an excel file on my phone?
What is wrap text in excel?
MS Excel Microsoft 
