0

I'm working on a job where they assign specific styles to cells to indicate meaning about that cell.

Presently, we select the cells, and then do things like:

  • Assign a foreground color using the toolbar.
  • Assign a background color using the toolbar.
  • Assign Bold, Italics, Underline using their keyboard shortcuts.

I know I can record a VBA macro, and then modify it to assign all the desired styles and I guess assign the macro to a shortcut key, but I was just wondering if there was any sort of built-in functionality in Excel I could more easily setup and use to accomplish the same thing faster than writing / recording a macro to achieve the cell styling.

1

You could use custom cell styles Cell Styles,

See image below.

enter image description here

There are some default styles, or you can simply create your own to suit your needs.

The custom created cell styles are only for that specific workbook though only, not all of Excel,

This does mean any user can see & use them, great if sharing etc.

  • Can you use a shortcut key to assign the styles? Also does it work with an older version of excel, like 2010? (It's probably in there, just hidden) – leeand00 Mar 9 '18 at 12:59
  • for a short cut key I'm assuming you will have to go down the vba route, and yes they work in 2010, in fact you get better viability of them in 2010 i think. – PeterH Mar 9 '18 at 13:00
  • If you want to avoid VBA, and you're only applying styles, you could apply it once then press CTRL + Y to redo the action. If you highlight an already formatted cell and double click the format painter, you can apply the style elsewhere with a single click. There are also plenty of add-ins out there that might save you some time and clicks: excelcampus.com/keyboard-shortcuts/… – P Fitz Mar 9 '18 at 13:13
  • @PFitz I'm not afraid of VBA, it just seems like too much trouble to do something so simple... – leeand00 Mar 9 '18 at 13:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.