We’ve shown you how to hide cells, rows, and columns and how to hide worksheets/tabs and entire workbooks in Excel. Additionally, you can hide items such as comments, formulas, overflow text, and gridlines. We’ll show you how to hide these items.
If you use a worksheet in your Excel workbook to hold values or formulas referenced on other worksheets, you may not want that worksheet visible on the tab bar at the bottom of the Excel window. The good news is you can easily hide worksheets in Excel.
If you’re short on screen space, you may want to hide parts of the Excel window, such as the ribbon and the worksheet tabs. We’ve already shown you how to hide the ribbon, so here we’ll show you how to hide the tabs.
There may be times when you want to hide information in certain cells or hide entire rows or columns in an Excel worksheet. Maybe you have some extra data you reference in other cells that does not need to be visible.
Opening a Word document as read-only helps prevent unintentional changes you make to the document from being saved. Read-Only mode does not allow you to make any changes to the document, preventing you from inadvertently saving changes. We will show you how to open any Word document as read-only.
Your Android device came with a default image set as the wallpaper on the Home screen. However, if you want a different image as your wallpaper, this is easily changed. There are several images included in the Android system or you can use one of your own images.
Word automatically formats items like quotes, bulleted and numbered lists, and horizontal lines. When you type at least three dashes, underscores, or equal signs in a paragraph by themselves and press “Enter”, the characters are automatically converted to a single, thick single, or double horizontal line, respectively.
Paragraph and character styles in Word are part of the basic structure of every document you create in Word. When you use either the built-in styles, or custom styles you’ve created, you might want to use the keyboard to quickly apply the styles to your content.
Word comes with some useful layouts for viewing your documents in different situations. These layouts include a print-friendly layout, a webpage layout, and a new layout as of Word 2013 called “Read Mode” that’s aimed at viewing documents on modern devices such as tablets.
Every document in Word must have a template attached. If you’re using a custom template with the current document and you’ve forgotten which one it is, you can easily find out in Word. You can also easily change which template is attached to the current document.
As its name implies, the “Developer” tab in Office programs allows you to create applications to use with Office programs, write macros, run macros you previously recorded, use XML commands and ActiveX controls, use form controls, and is not available by default.
Recently, we showed you how to set the advanced, or built-in, properties and create custom properties in a Word document. These properties can be inserted into your documents using fields. This is useful if you have common words, phrases, or values you use often in your documents.
We recently showed you how to set the user information in Word. Word also stores several additional advanced properties related to your documents. Some of these are displayed on the “Info” screen and you can change these properties, as well as create custom properties.
Adding a header of footer in Word allows you to add information that’s displayed on every page. There may be various reasons for adding the filename to the header or footer, and we’ll show you how to do this.
By default, the author of a document is set to the user name you entered when you installed Word. However, you can change the user name, thus changing the main author, as well as add authors to or remove authors from a document.
Recently, we showed you how to only use the main dictionary (not any custom dictionaries) when performing a spell check or automatically checking spelling as you type. You can do the same in Outlook, but it’s a slightly different procedure to change this setting in Outlook.
Word allows you to add custom dictionaries to use when checking spelling. When you run the spell checker or when Word automatically checks spelling as you type, the words in your document are compared to the main dictionary and any custom dictionaries you may have added.
A new feature was introduced in Word 2013 that allows you to collapse parts of your document and expand them when you want to view that content again. This feature makes it easier to find and view only what you want.
Headers and footers are useful for adding things such as page numbers, dates, file names, and disclaimers to documents. Word allows you to add headers and footers with built-in, ready-made layouts or add your own custom headers and footers.
We recently showed you how to set the user information in Word. Word also stores several additional advanced properties related to your documents. Some of these are displayed on the “Info” screen and you can change these properties.
Have you tried to schedule a meeting with people in another time zone and gotten the time wrong? It would be helpful if you could view both time zones on the calendar in Outlook so you can quickly see the corresponding time when scheduling meetings.
When you install Word, you are asked to enter your name and initials. This user information is stored in Word and you can automatically insert this information into your documents, such as into the return address of an envelope.
Outlook allows you to add a second time zone to your calendar, but two time zones, including your local time zone, is all you can view in Outlook. However, there is a way around this limitation.
Have you opened a document in Word but forgotten where it’s stored? You may need to access other documents in the same location or back up your documents. There are several ways to use Word to find the location of a file.