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 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...
by Laura | May 24, 2019 | Microsoft Excel Tips
In this case, you could use one of Excel’s most popular and useful functions, the IF function. You use an IF statement to ask Excel to test a condition and to return one value if the condition is met, and another value if the condition is not met. Another way of...
by Laura | May 21, 2019 | Microsoft Excel Tips, Microsoft Outlook, Microsoft PowerPoint Tips, Microsoft Word Tips
Unfortunately, there is no one-key shortcut for the Format Painter, but it’s a 2-step process, which makes sense. When you want to copy a format, highlight a sample of the text and instead of pressing Ctrl+C, press Ctrl+Shift+C. Now select the text you want...
by Laura | May 16, 2019 | Microsoft Excel Tips
Yes, you can create a macro that does this. You can copy and paste the code below to add the current date and time to the file name of a file. On the Developer tab, click on Visual Basic. When the Visual Basic window opens, click on Insert > Module. When...
