web analytics

25 TOP TIPS FOR MICROSOFT EXCEL – PART 2

ExcelIcon01

This article is Part 2 of  the Top 25 Basic Level Tips for using Microsoft Excel. For almost every tip there is an adequate screenshot to make the visual perception of the user’s task more precise. It’s interesting that some of the basic tips are the same for Microsoft Word and Microsoft Excel. Although this represents a sort of tutorial that is on a basic level, it gives solution to some very frequently asked questions by the novice users. Presents step by step solutions to procedures like: Opening and saving files, undo and redo actions, text formatting, shortcut keys to some actions. Some of the more complicated actions explained are creating tables, adding and deleting rows and columns, selecting multiple objects and other. The Content is divided in two parts.

The counting for the 25 best tips for Microsoft Excel continues here:

16. Enter multiple lines in the cell, select the cell where you like to add more lines, press F2 key or double click on that call and press Alt + Enter.

46

(Still one cell even there are multiple lines).

17. You can Merge two neighbor cells.

First, select the two cells,

47

then click the Merge & Center Icon in the alignment group.

48

If there is text in any of the cells, it will be aligned central.

18. To apply outline border around selected cells, first select the cells and then press Ctrl + Shift + 7.

49

19. Add Columns in Microsoft Excel with right click on Column Header,

50

and select Insert. When adding a column in Microsoft Excel, the column of the insertion point moves to the right to make room. Add Rows in Microsoft Excel with right click on Row Header,

51

and select Insert. When adding a row, the row of insertion point is pushed down.

20. Delete columns in Microsoft Excel with right click on Column Header and selecting Delete.

21. Delete rows in Microsoft Excel with right click on Row Header and selecting Delete.

22. To add more than one new column, select more than one column in the column header.

52

  • In the column header, drag select the number of columns you want added to the spreadsheet,
  • Right click on the selected columns,
  • Choose Insert on the selected menu,
  • The new columns will be inserted to the left of the selected columns.

23. To delete multiple columns in Microsoft Excel,

  • First, select the columns you want to delete from the spreadsheet,
  • Second, right click on the selected columns,
  • Choose Delete  from the menu.

24. To change the worksheet Tab Color,

  • Click on the tab(s) on the worksheets you want to re-color. To select more than one tab hold down the Ctrl key on the keyboard and click on each tab with the mouse cursor,
  • Right click on one of the selected worksheets,
  • Select Tab Color from the menu, and pick the preferred color from color palette.

53

25. If the text exceeds the length of the cell you can use Wrap Text Icon in the Paragraph group of icons.

54

 

Leave a Reply