Be efficient with Excel

Learning all the features of Excel can somehow be overwhelming as this may take you forever, but since we have come up with the list of the most useful tips, all you will have to do is continue reading.

1. New line of text

Pressing the Enter key would not result in the creation of a new line of text. Rather than pressing the Enter key, press Alt-Enter instead. As for Mac users, the key combination is Control-Option-Return.

2.  Resize Columns and Rows

Since the default height and width is not one size fits all, you will likely need to make adjustments so you can fit your input. Simply decide whether you want to modify the height or width of the window by clicking on the Home tab and then the Format button on the toolbar. To make the column or row match the precise desired measurement, enter the amount and click OK.

In case you wish to manually resize it, you may do so via moving the mouse pointer between the columns and rows then click the left mouse button. Once the floating balloon appears, drag and extend until the desired size is attained.

3. Add or remove columns, rows, or cells

You may quickly add a column, row, or cell using the Insert and Delete Cells commands. Within the Cells group, click Insert, then select the desired option. You may also delete a column inside a group by choosing Delete. Similarly, right-clicking the column or cell row works.

4. Freeze Panes

The Freeze Panes tool allows you to browse across a spreadsheet without losing focus on a certain section of data. Select the first row or column of data in the sheet. Select the View tab, then Freeze Panes from the menu then your headers or columns will scroll with you.

5. Change text alignment

Format Cells dialog allows you to align text within cells to create a register or label. Right-click the selected cells, then choose Format Cells. Alternatively, you may move the text around with your mouse or input a value into the text box. When you click OK, the text within the cells will appear slanted.

6. Use Cell Protection

Here’s how you can safeguard a collection of cells while you’re sharing a workbook with others. To begin, turn on the Protect Sheet. To protect a sheet, go to the Format menu, then hit Protect Sheet. Make a list of the kind of adjustments you want to stay away from. Enter your password, then OK, and then OK again. Select the rows or columns you want to protect from other users. Click the Format menu, then click Lock Cell.

7. Special Formatting to Currency and Numbers

The Numbers tab in the Format Cells dialog lets you apply currency values and compute decimal places. Right-click the numbers, then select the Numbers tab. Right after that, choose the decimal places and currency format from the Category list.

8. Reveal Formulas

To easily check through formulas used in your sheet, select the Formulas tab, then click Show Formulas in the Formula Auditing group. It’s an excellent technique to detect faults or just comprehend numbers.

9. Manipulate Charts

Creating charts in Excel is a great way to graphically communicate data. In Excel, just choose a range of data, click the Insert tab, and then click the See all charts button.

Pick a chart style from the All Charts tab. Hovering over a sample shows a preview of the chart. To enter the chart into the spreadsheet, click OK. You may also move it to a new sheet by clicking Move Chart, New Sheet, and OK.

10. Maximize Printing Options

Spreadsheets look excellent on widescreen monitors but they may end up unreadable once printed. Good thing printing from Backstage allows you to adjust the page size and orientation. Keep in mind that Spreadsheets should be printed either in landscape on legal size paper.