How-to guides and tutorials to help you perform specific tasks and use the Microsoft Excel 2010 spreadsheet application.
The first time you try and print a large spreadsheet in Microsoft Excel, there’s a good chance that something will go wrong. There won’t be… Continue Reading How to Prevent Extra Pages from Printing in Excel 2010
Go to Page Layout, open Page Setup, and on the Margins tab check Horizontally and Vertically under Center on page. How to preview and apply to many sheets. Continue Reading How to Center a Worksheet Horizontally and Vertically in Excel 2010
Change cell shading in Excel 2010 with Fill Color, Format Cells patterns and gradients, Cell Styles, or conditional formatting, and remove shading. Continue Reading How to Change the Cell Shading Color in Excel 2010
If you have used Excel for a while, then you have probably acclimated yourself to the visual appearance of the program. But the colors of… Continue Reading How to Change the Color Scheme in Excel 2010
Print on legal paper in Excel 2010 with Page Layout > Size > Legal, then check the preview and printer tray. Plus scaling tips for the page. Continue Reading How to Print on Legal Paper in Excel 2010
Put a picture in a cell in Excel 2010 by sizing it to the cell and setting Move and size with cells. Newer Excel adds Place in Cell. Continue Reading How to Insert a Picture in a Cell in Excel 2010
Lock a picture to a cell in Excel with Move and size with cells or Place in Cell, and protect the sheet so images can’t be moved or deleted. Continue Reading How to Lock an Image to a Cell in Excel
Insert a new worksheet in Excel with the + button, Shift + F11, Home > Insert > Insert Sheet, or a right-click, and add several sheets at once. Continue Reading How to Insert a New Worksheet in Excel (4 Ways)
Microsoft Excel 2010’s default state is a series of cells laid out in rows and columns of equal sizes. But as data is added to… Continue Reading How to Unmerge Cells in Excel 2010
The gridlines that separate your cells in a Microsoft Excel 2010 spreadsheet are helpful for keeping cells visually distinct from one another. So when those… Continue Reading Where Did the Gridlines Go in Excel 2010?