Formatting Only the Selected Cells...

%3CLINGO-SUB%20id%3D%22lingo-sub-2375286%22%20slang%3D%22en-US%22%3EFormatting%20Only%20the%20Selected%20Cells...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2375286%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20searching%20for%20information%20on%20how%20to%20select%20a%20certain%20number%20of%20cells%2C%20ie.%20C2-C9%2C%20C5-C9%2C%20C8-C9...%20by%20using%20keyboard%20strokes%20only.%3C%2FP%3E%3CP%3EThen%2C%20right-clicking%2C%20and%20formatting%20only%20the%20selected%20cells.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2375286%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2375401%22%20slang%3D%22en-US%22%3ERe%3A%20Formatting%20Only%20the%20Selected%20Cells...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2375401%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1059879%22%20target%3D%22_blank%22%3E%40Charlie1280%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EUse%20the%20arrow%20keys%20to%20move%20to%20the%20first%20cell%20of%20the%20range%20that%20you%20want%20to%20select.%3C%2FP%3E%0A%3CP%3EHold%20down%20shift%20and%20use%20the%20arrow%20keys%20to%20extend%20the%20selection.%3C%2FP%3E%0A%3CP%3EPress%20Ctrl%2B1%20to%20activate%20the%20Format%20Cells%20dialog.%3C%2FP%3E%0A%3CP%3EUse%20Ctrl%2BTab%20to%20move%20to%20the%20next%20tab%20of%20the%20dialog%2C%20Ctrl%2BShift%2BTab%20to%20move%20to%20the%20previous%20tab.%3C%2FP%3E%0A%3CP%3EUse%20Tab%20and%20Shift%2BTab%20to%20move%20between%20the%20elements%20of%20the%20tab%20page.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20select%20any%20range%2C%20contiguous%20or%20not%2C%20on%20a%20worksheet%20as%20follows%3A%3C%2FP%3E%0A%3CP%3EPress%20F5%20or%20Ctrl%2BG%20to%20activate%20the%20Go%20To%20dialog.%3C%2FP%3E%0A%3CP%3EEnter%20the%20range%20address%20in%20the%20Reference%20box.%20Separate%20areas%20with%20the%20list%20separator%20(probably%20a%20comma%20on%20your%20system)%2C%20e.g.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EC2%3AC9%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am searching for information on how to select a certain number of cells, ie. C2-C9, C5-C9, C8-C9... by using keyboard strokes only.

Then, right-clicking, and formatting only the selected cells.

1 Reply

@Charlie1280 

Use the arrow keys to move to the first cell of the range that you want to select.

Hold down shift and use the arrow keys to extend the selection.

Press Ctrl+1 to activate the Format Cells dialog.

Use Ctrl+Tab to move to the next tab of the dialog, Ctrl+Shift+Tab to move to the previous tab.

Use Tab and Shift+Tab to move between the elements of the tab page.

 

You can select any range, contiguous or not, on a worksheet as follows:

Press F5 or Ctrl+G to activate the Go To dialog.

Enter the range address in the Reference box. Separate areas with the list separator (probably a comma on your system), e.g.

 

C2:C9