MS Excel 2016 Shortcuts Explanation 4th Part

This is the 4th part of shortcuts explanation series used in Microsoft Excel 2016. I will be explaining fonts editing in this post. From now on I will provide details of each section of the ribbon. I hope this will help you become more efficient user in Excel. Like before I have tested all of these shortcuts in latest version of MS Excel 2016.

Note; If you are following my posts you don’t need to re-read the following points.

Points to consider:

  • Some of these shortcuts might not work in all versions of Microsoft Word (As I was able to test these only in MS Word 2016).
  • Device without function keys (F1-F12) on its keyboard i.e. Chromebook, certain shortcuts will not work for you.
  • The plus sign means you have to press both mentioned keys together.

Ctr+B or Ctr+2

  • Use this shortcut key to make the selected cell or selected text within the cell bold.
  • This is perhaps the most used shortcut and works in other Microsoft applications and in WordPress too.
  • Please note that in other products Ctr+B will work but Ctr+2 would not achieve the same task/result.
  • Press once and the selection will become bold and press twice to undo or use Ctr+Z.
  • If selected cell is already bold use it to make it a normal again.
  • You can also achieve the same task by pressing Alt Then H Then 1.

Ctr+I or Ctr+3

  • Use this shortcut key to make the selected cell or selected text within the cell content Italic.
  • This is also the most used shortcut and works in other Microsoft applications and in WordPress too.
  • Please note that in other products Ctr+B will work but Ctr+3 would not achieve the same task/result.
  • Press once and the selection will become italic and press twice to undo or use Ctr+Z.
  • If selected cell is already Italic content, use it to make it a normal again.
  • You can also achieve the same task by pressing Alt Then H Then 2.

Ctr+U or Ctr+4

  • Use this shortcut key to underline the selected cell or selected text within the cell content.
  • This is also the most used shortcut and works in other Microsoft applications and in WordPress too.
  • Please note that in other products Ctr+B will work but Ctr+4 would not achieve the same task/result.
  • Press once and the selection will be underlined and press twice to undo or use Ctr+Z.
  • If selected cell is already underlined content, use it to make it a normal again.
  • You can also achieve the same task by pressing Alt Then H Then 3.

    Ctr+5

  • Use this shortcut for strikethrough the selected cell i.e. Strike through.
  • This shortcut will not achieve the same task in other applications like MS Word.
  • If selected cell is already having strikethrough effect use it to make it a normal again.

Ctr+Shift+F or Ctr+Shift+P

  • Use this shortcut to open Format cell dialogue box.
  • Use Tab button move around for Font, Font Type, Size etc.
  • This Box gives you a variety of options other than what you see in regular ribbon like effects i.e. double underline or strikethrough super and subscript etc.
  • I will explain the other tabs according to the ribbons they are used in.
  • Also Note that Ctr+1 will also open the Format Cells dialogue box.

Increase/Decrease Font Size (Alt Then H Then F Then G) & (Alt Then H Then F Then K)

  • This is generic shortcut for increasing or decreasing the font size.
  • Note that if the cell which you have selected have an Odd font size this shortcut will increase or decrease the size by 1 point. i.e. 11 to 12.
  • Alternatively, if your selected cell has even font size this shortcut will increase or decrease the font size by 2 points. i.e. 12 to 14.
  • This shortcut also works in MS Word with same effect.

Background Cell Color (Alt Then H Then H)

  • Use this shortcut to color the background of the cell to make them standout.
  • This is also a generic shortcut and works well with MS Word too.
  • Use arrow keys to move around for selection of specific color.

Cell Border (Alt then H Then B)

  • Use this shortcut key to make cell borders from a range of choices.
  • You can use this options for making receipts or before printing a table.
  • For me All Borders and thick borders option was the most I used. So, you can remember the short keys for your most used border style.

Font Type (Alt Then H Then FF), Font Color (Alt Then H Then FC), Font Size (Alt Then H Then FS)

  • Use these generic short key for changing font, font color and size of the selected cell.
  • This is rather long process and also slow so I use the Cell Format dialogue box short key for all of my font style editing.

    Previous Part

    Next Part

Save

Save

Save

Share This Post

Recent Articles

© 2017 PC Shelf. All rights reserved. Site Admin · Entries RSS · Comments RSS
Powered by WordPress · Designed by Theme Junkie