I have seen spreadsheets that have completely different layouts on different pages. I know how to section break a Word document, but I can't see how to do it in Excel.
Do you mean for printing? If you go to the Page Layout tab, then within the Page Set-up section you can set the print area and insert breaks where you want them. Take a look and let me know if you need any help.
Do you mean for printing? If you go to the Page Layout tab, then within the Page Set-up section you can set the print area and insert breaks where you want them. Take a look and let me know if you need any help.
No, I am referring to a spreadsheet that on one page has a certain layout of rows and columns, while the next page down has a completely different layout of rows and columns. I'm trying to find an example to show you but haven't retrieved it yet.
You can alter the column widths and row heights if that's what you mean? Or are you saying that within the same sheet (ie tab) there are different layouts?
You can alter the column widths and row heights if that's what you mean? Or are you saying that within the same sheet (ie tab) there are different layouts?
Yes, please see file attached. It has on same sheet, on same page, different layouts of rows and columns. I has to convert it to a .pdf to upload it to you.
Ah ok, what you are looking to do is merge cells - that's how they have made some of the columns look wider. If you look at the cells under the 'Description' heading it looks like they have merged cells across 5 columns together (you can see from the grid at the bottom).
To merge cells, highlight the cells you want to merge and click on the drop down arrow next to the 'Merge & center' button. You can then choose how you want to merge the cells. You can do this with any block of cells, so it can be across multiple rows and columns.
The longer way to do it is to right click on the highlighted cells. A menu will pop up and you want to click 'Format cells'. Pick the tab at the top that says 'Alignment', and then under the Text Control subsection tick the box to 'Merge cells'.
Hope this helps!
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.