Not every page in a Word document will fit neatly into the default printing scheme. For instance, you might need to drop a spreadsheet or wide table into a document that's using the Portrait print setting. In this case, you'd probably want Word to print the page containing the table in Landscape, while printing the rest of the document in Portrait. How can you get Word to accommodate both Portrait and Landscape in the same document? Last week we asked you to… List just one change you can make to an Excel spreadsheet to improve its performance.
- Njconner1 suggested converting formulas to static values to keep a busy spreadsheet from recalculating formulas that don't need recalculating.
- T8omo1 suggested disabling automatic calculation. That way, you decide when Excel calculates. That certainly speeds up data entry in a busy spreadsheet.
- Dlcartin recommended a fix for conditional formatting.
- Wilson.baptista.jr groups dependent formulas.
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.