Conditional formatting excel 2016 tips and tricks

CONDITIONAL FORMATTING EXCEL 2016 TIPS AND TRICKS CODE
CONDITIONAL FORMATTING EXCEL 2016 TIPS AND TRICKS PLUS

Enter the custom format and press the OK button. Go to the Number tab in the Format Cells dialog box and then select Custom under the category. You can also use the Ctrl + 1 keyboard shortcut. Highlight any cells you want to format then open the Format Cells dialog box by going to the Home tab and then clicking on the small icon in the lower right corner of the Number section.

CONDITIONAL FORMATTING EXCEL 2016 TIPS AND TRICKS CODE

Display Numbers in Thousands or Millions with a Custom Number FormatДisplay numbers as thousands using the custom format code 0.0, 'k'.Дisplay numbers as millions using the custom format code 0.0, 'M'. This trick will also work for automatically adjusting row height. The column width will adjust so that all data in the column fits. Hover your mouse cursor over the column border until it changes to a line with two arrows then double left click. You can automatically adjust the column width to fit the data it contains. You can select the entire worksheet by clicking on it. The intersection of the column and row headings is actually a button. This will open up the Activate, and you can select any of the worksheets listed then press the Ok button to go to that sheet. Right click on either of the small arrows to the left of all the sheet tabs. There is an easy navigation method available. If you end up with a lot of sheets in your workbook, navigating through them can become difficult. You can also insert a new sheet from the Home tab then Insert then Insert Sheet or by using the Shift + F11 keyboard shortcut.

CONDITIONAL FORMATTING EXCEL 2016 TIPS AND TRICKS PLUS

The quickest way to add a new sheet into a workbook is to left click on the small plus sign to the left of all the sheet tabs. Then you can type a new name and press Enter to complete it. You can quickly rename any sheet with a double left click on the sheetвЂ™s tab in the lower left area of the workbook. When you create a new sheet Excel will automatically give it a sequential name like Sheet1, Sheet2, Sheet3 etc. Now click on the Gridline color option and select a colour and press the Ok button. Select the worksheet from the drop down menu for which you want to change the gridline colour.

In the Excel Options menu go the the Advanced settings, then scroll down to the Display options for this worksheet. This can be found in the Excel Options menu. ItвЂ™s possible to change the gridline colour from the default grey to a variety of other colours. Go to the View tab in the ribbon then deselectВ the Gridlines options in the Show section of the ribbon. Remove Gridlines from a SheetДЇor a much cleaner and more modern look to your worksheets, remove the grid lines from any worksheet. This is a valuable tip in itself, but we will explore some of the more useful options later on. The left hand side of the dialog box contains tabs to organize the various options into different categories and the right hand side is where you can adjust the settings. This will open up the Excel Options menu where you can find all of ExcelвЂ™s many different settings options. You can find these all in the Excel Options menu.

Conditional formatting excel 2016 tips and tricks