by Laura | Jun 3, 2019 | Microsoft Excel Tips
If you want to move a sheet to another workbook, right-click on the sheet name and select Move or Copy. The Move or Copy dialog box will list all of your open Excel workbooks. So make sure the destination file is open before you do this. (There will also be an...
by Laura | May 31, 2019 | Microsoft Word Tips
It’s easy to modify selected borders if you understand how to use the settings in the Borders and Shading dialog box. These are the setting in Word 2010. (The Setting: boxes at the left are slightly different in later versions but the idea is the same.) In the...
by Laura | May 28, 2019 | Microsoft Word Tips
You can certainly do it easily enough with styles. Format a snippet of code the way you want it to appear (indentation, font face, font size, etc.) and select it. Right-click and from the drop-down that appears select Styles, then Save Selection As a New Quick...
by Laura | May 27, 2019 | Microsoft Excel Tips
To make an Excel sheet read only, navigate to that sheet and click on Format on the Home tab. Then click on Protect Sheet. Depending on your version of Excel you can also select Protect Sheet from the Review tab. When the Protect Sheet dialog box opens, make sure the...
by Laura | May 25, 2019 | Microsoft Excel Tips
Use the Cell() Function. The CELL function returns information about the formatting, location, or contents of a cell. It has the following syntax: CELL(info_type, [reference]) The first argument is an attribute and the second argument is a cell reference. There are...
