call us now on 020 8203 1774
or email on enquiries@theittrainingsurgery.com
Category: IT Quick Tips, Microsoft Excel 2010, Tips for Windows Users
Quick Tip for Microsoft Excel 2010 Here I show you how to copy Formatting using Autofill in Microsoft Excel 2010. AutoFill also allows you to copy formats from one cell to another. To copy formatting using Autofill 1. Format the content in your first cell. 2. Position your cursor so it hovers over the bottom right […]
Read MoreCategory: IT Quick Tips, Microsoft Excel 2010, Tips for Windows Users
Quick Tip for Microsoft Excel 2010 Here I show you how to Create Cell Styles in Microsoft Excel 2010. You can create your own Cell Style to allow you to rapidly format your workbook consistently. To create a cell style 1. Format a cell/some cells in the style you would like to add to Cell Styles […]
Read MoreCategory: IT Quick Tips, Microsoft Excel 2010, Tips for Windows Users
Quick Tip for Microsoft Excel 2010 Here are some steps on how to apply Cell Styles in Microsoft Excel 2010 Cell styles are pre-set formats for cells. They can be reused to help your sheet’s formatting look consistent. Select the cells you would like to apply a style to (1) Go to the Styles group on […]
Read MoreCategory: IT Quick Tips, Microsoft Excel 2010, Tips for Windows Users
Quick Tip for Microsoft Excel 2010 Here is how to set the Page Margins in Microsoft Excel 2010 1. Go to the Page Layout tab on the ribbon 2. Go to the Page Setup group 3. Click on Margins (1) 4. Choose Normal, Wide or Narrow (2) To set custom margins using sizing you set yourself […]
Read MoreCategory: IT Quick Tips, IT Training Blog, Microsoft Excel 2010, Tips for Windows Users
Quick Tip for Microsoft Excel 2010 Here is how you Hide and Unhide Rows and Columns Microsoft Excel 2010 Sometimes you might want to present your information but choose not to show one or more columns of data. In Excel you can hide one or more columns so the information is still used in calculations on the […]
Read MoreCategory: IT Quick Tips, Microsoft Excel 2010, Tips for Windows Users
Quick Tip for Microsoft Excel 2010 This is how you Print Rows to Repeat with Titles in Microsoft Excel 2010. You can set Excel to Print Tiles if you have titles on the first row of your document, and you would like the titles to print on every page. To set Excel to Print a Row containing […]
Read MoreCategory: IT Quick Tips, Microsoft Excel 2010, Tips for Windows Users
Quick Tip for Microsoft Excel 2010 Here is how to Print Row and Column Headings in Microsoft Excel 2010. You can set your workbook so the row and column headings print. To set Excel to print row and column headings Go to the Page Layout tab on the ribbon Go to the Page Setup group Click […]
Read MoreCategory: IT Quick Tips, Microsoft Excel 2010, Tips for Windows Users
Quick Tip for Microsoft Excel 2010 Here is how you create different headers and footers in Microsoft Excel 2010 Ensure you are in headers or footers On the Header & Footer Tools tab, click on the Different Odd & Even Pages checkbox Add your different header and footer elements to the odd and even pages […]
Read MoreWould you like to talk through your IT Training needs?
Just send through your details and we'll get back to you.
