First look for the Outline menu in the Data tab of the ribbon. Click its expand button in the lower right corner to see the full menu. Click its expand button in the lower right corner to see the full menu.

By You can apply gridlines or borders to your Microsoft Excel worksheets. Gridlines are the faint, gray-blue lines you see onscreen that separate the rows and columns. (By default, gridlines appear onscreen but not in print.) Borders are the lines that appear around one or more sides of each cell. To control how gridlines appear, display the Page Layout tab and then mark or clear the View and/or Print check boxes in the Sheet Options/Gridlines group. (There Gridlines check box on the View tab controls only the onscreen display, not the print setting.) Borders can be any color or thickness you want. Borders always display onscreen and always print, regardless of settings. Borders are useful for helping the reader’s eyes follow the text across the printed page, and for identifying which parts of a spreadsheet go together logically.

The easiest way to apply and format borders is to use the Borders button’s drop-down list on the Home tab. Select the range of cells to which you want to apply the border, choose Home→Font→Borders. From the list of borders that appears, choose one that best represents the side(s) to which you want to apply the border. The border will apply to the outside edges of the range you select. So, for example, choosing Top Border applies a top border only to the cells in the top row of the range, not to the top of every cell in that range. • To add a border on all sides of each cell in the range: Choose All Borders. • To remove the border from all sides of all cells in the selected range: Choose No Border.

• To add borders on more than one side but not all sides: Repeat the process several times, each time choosing one individual side. If you want to choose a specific color, style, or weight for the border, choose Home→Font→Borders→More Borders. The Format Cells dialog box appears with the Border tab displayed. In the Style area, click the desired line style. In the Color area, open the drop-down list and click the desired color. In the Presets area, click the preset for the sides you want to apply the border to: None, Outline, or Inside.

Free software for mac. If you want the border around each side of each cell, click both Outline and Inside. If you choose a border style and color but don’t apply it to any sides of the range, that’s like selecting nothing at all.

2016-03-22 16:-03-22 16:33:07 Bookkeeping English Microsoft Excel is an integral part of most businesses. See 10 easy tricks, shortcuts and hacks that will help you become an Excel super.

10 Microsoft Excel Tricks, Shortcuts and Hacks QuickBooks. Microsoft Excel is an integral part of most businesses. Some people relish the capabilities of Excel, finding it a useful tool that allows them to easily manage, report on and illustrate tables of data. Others, however, find it tedious and downright obtuse, unable to make heads or tails of what exactly Excel can do from them, aside from keeping things in neat columns and rows. Below is a list of 10 easy tricks, shortcuts and hacks that will put you on the path to being an Excel super user.

(Note: There are a many versions of Excel, including versions for desktop (Windows, Mac OS X) and mobile (iOS and Android) operating systems. The visuals are screenshots from a Mac version of Excel. These tips were confirmed to work on a Mac and Windows desktop, but may apply to other versions as well. This piece also discusses keyboard shortcuts for use in a Windows OS.

For Mac, replace the “Control” key with the “Command” key.) 1. Select All Cells in a Spreadsheet at Once Do you need to reformat your font or make some other sweeping change to your Excel workbook?

An easy way to select all the cells in the document is to click on the square in the upper left-hand corner where the top of the rows and columns meet. Clicking on this box will highlight all of the cells in the document, even empty cells. If you prefer keyboard shortcuts, you can also select all cells by pressing the “Control” and “A” buttons at the same time. Copy a Worksheet From 1 Workbook to Another This is helpful if you’re looking to merge data across two workbooks together and don’t want to reformat all of your data in either workbook.