When I use Excel 2003 or 2010 at work (on a PC), the worksheet is very wide. The columns would never fit on a printed page. When I open Excel 2004 for Macs, the size of the worksheet is fitted to the printed page option (unless I open a file from work).
How do I remove the paper size limitation, such that I can make a very wide spreadsheet?
Column widths are in inches. How to I change it to the same units used on the PC? i.e., instead of 1" or whatever, I want to say ‘10’ or ‘12’.
Splitting lines on Windows versions is Alt-Enter. If that doesn’t work on Mac versions, try the other modifier keys + Enter (Control, Command, etc.)
If you want word wrap, just add a blank line to the bottom of the cell by doing the above. Then you can go back and delete the line.
Or, if you need it for more than one cell, highlight all the cells you want to allow Word Wrap in*, and then right click and choose Format Cells. Then click the Alignment tab, and check the Word Wrap option.
Finally, if you want to have this or any other option from the start, you can save it as an Excel template. When saving, choose Template from the type drop down, and save that in your Office templates folder. Save it as workbook.xlt for it to be the default.
I’m still looking for information on where your Templates folder is on a Mac, but maybe you can find it yourself. It should be a subfolder of your User folder–you know, the folder that has the same name as your user name.
*If it’s every cell in the worksheet, click on the upper left corner.
I may have found the Templates folder: Try ~/Library/Application Support/Microsoft/Office/User Templates/. If it’s the right folder, it should have a file called “normal.dot” in it.
Not six in the ayem yet, and I haven’t had coffee…
I want to be able to split lines in cells in one column. I know how to get rid of them on the Mac, thanks to> someone in a previous thread: Copy the Excel spreadsheet into Word, Find & Replace ==> Special == Manual line break, change to nothing, copy back into a new Excel spreadsheet… And I know how to get rid of them on the PC: F&R ALT-010 to nothing. I assume I could type ALT+010 into the appropriate places (or F&R the common strings) to insert in-cell line breaks, but I’m not on a PC and can’t do ALT codes. Of course I have wrap text turned on.
I’ve attempted to insert a break by looking at the Insert menu, but didn’t find anything there. I’ve also tried Shift+Return, Shift+Alt+Return, Cmd+Return, Shift +Cmd+Return, Crtl+Return, Option+Return, Shift+Option+Return, and the same modifier keys in combination with the Enter key. No joy.
I’ve never used templates, so I’m not sure what to look for. I used Finder too look for normal.dot, and it is not found on my hard drive.