Macros in Word and Excel provide the ability to save time on predictable, repetitive tasks. You can record a series of actions into a macro and then simply click a button to run the macro and perform the task.
Creating and removing numbered lists in Word is easy using the “Numbering” command on the ribbon. However, if you prefer using the keyboard, there is a way to quickly create a numbered list using a keyboard shortcut.
The Track Changes feature in Word allows you to mark changes you make in a document so anyone else working on the document knows what changes you made. By default, these marks display on the printed document, but you can prevent them from showing.
If your worksheet takes up more than one page when printed, you can print row and column headings (also called print titles) on every page so your data is properly labeled, making it easier to view and follow your printed data.
We’ve shown you how to add “Page X of Y” to a header of footer of large spreadsheets in Excel. The same thing can be done in Word for longer documents. It’s a bit different than in Excel, so read on to find out how.
The recent release of Office 2016 adds some useful new features and improvements and is now the default version installed as part of Office 365. However, if you want to install Office 2013 instead or on another machine, that is easily done.
You can add text, such as page numbers, filename, worksheet name, and date, to the header and footer on your spreadsheet. But, what if you want the first page of your worksheet to have a different header than the rest? That’s an easy task to accomplish.
If you have a large spreadsheet in Excel, you may want to add page numbers. Doing so is easy, and you can even add them in the format of “Page X of Y”. Read on to find out how.
In Word, the “Insert” key on the keyboard can be used to switch between Insert and Overtype modes. However, it can also be used as a shortcut key for inserting copied or cut content at the current cursor position.
Instead of using the cut and copy commands, “Ctrl + X” and “Ctrl + V”, to move content, you can more quickly move text using fewer keystrokes. Any content, including text, graphics, and tables, can be moved using the “F2” key and the “Enter” key.
Microsoft Office 2016 has improved their collaboration features so multiple authors can work on a document in real time. You can share a document in OneDrive and view who is working on it, and even get a link to send others for easy access to the document.
One of the new features in Office 2016 is “Ink Equation”. This feature allows you to insert equations into Word, Excel, and PowerPoint by handwriting them. Ink Equation is designed to be used with a tablet pen on a tablet PC.
It’s easy to add email accounts, such as iCloud, Google, Yahoo, or Outlook.com, to an iOS device. However, what if you have a self-hosted email account with a custom domain? No worries. That’s just as easy.
If you currently have a subscription to Office 365, you’ll be pleased to know you can upgrade to Office 2016 right now in just a matter of a few minutes. Today we’ll quickly show you how to do that on a Windows PC and Apple Mac.
Today marks the release of Microsoft Office 2016. We’ve tested some of the more notable, cool new features and enhancements, which we’ll show you here in our standard How-To Geek style screenshot tour with lots of pictures.
Section breaks in Word allow you to break up your document into sections and format each section differently. When you create a new document there is only one section by default, but you can add different types of section breaks as needed.
We all have a pretty good idea of the fonts that we do and do not have installed on our computers, but what is going on when you receive a Microsoft Word document that ‘displays’ a font you know is not installed on your computer? Today’s SuperUser Q&A post helps clear things up for a confused reader.
If you have a spreadsheet where the text in your column headings (not the lettered column headings) is longer than the text in the columns, and there are a lot of columns, you may want to rotate the text in your headings so the columns become narrower.
If you have a table with many rows and columns, it can be difficult to read. Adding shading to the table can make reading the data in our table easier. For example, you can add shading to every other row and/or column using a color or pattern.
Microsoft OneNote is now free to use on and sync among all your devices, such as computers, tablets, and phones, as well as on the web. So, what if you’re using Evernote and want to switch? No worries. It’s easy to convert your Evernote notebooks to OneNote.
Word allows you to put a border around most types of items in your document, such as text, pictures, and tables. You can also add a border to either all the pages in your document or certain pages in your document using section breaks.
By default, when you insert a table, there is a simple, black border around all the cells in the table. However, you may want to change or remove the borders, and there are a few easy ways you can do this.
Normally, Excel uses the A1 cell reference style which uses letters for column headings and numbers for row headings. However, if you notice there are numbers on both the row headings and column headings, that’s the R1C1 cell reference style. No worries. It’s easy to change it back.
Word tracks certain summary information about documents, such as the number of words in a document. If you want to display the number of words contained in your document in the document itself that you can quickly update, this is easily accomplished.
Underlining is a common task in Word, and easily done, but what if you need to overline (also called overscore or overbar), some text? Overlining is common in scientific fields, but there are various reasons for overlining text. However, Word doesn’t make it easy.