Excel Keyboard Shortcuts to Fill a Series Here is the latest installment in my series of video tutorials on Keyboard Shortcuts in Excel. In this lesson, I demonstrate how to Fill a Series with Values or a Formula Down or to the Right. In order to assign it to the macro place your cursor in the Shortcut Key area and press Shift + Q. The window should look like this. When you click OK, the macro starts to record your movements. Now, you need to fill any cell with the desired color and click the Stop Recording button.
How to highlight all cells referenced by a formula in Excel?
This article is talking about highlighting all cells which was referenced by a formula in Excel. Please follow the below two methods to get it done.
Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier...
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by80%
Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words...
Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum...
Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns...
Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Create Mailing List and Send Emails by Cell's Value...
Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
More than300 powerful features; Works with Office2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.
Highlight all cells referenced by a formula with Shortcut key
Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari!
Save 50% of your time, and reduce thousands of mouse clicks for you every day!
This section will recommend you to use Shortcut key to select all cells which was referenced by a formula, and then manually fill color to them.
1. Supposing E1 is a formula cell, and you need to highlight all cells which was referenced by it. Please select the formula cell E1, then press Ctrl + [ (the open-square-bracket) keys simultaneously.
2. Now cells that referenced by this formula are selected, please specify a fill color to highlight them. See screenshot:
Highlight all cells referenced by a formula with VBA code
You can also running VBA code to highlight all cells which was referenced by a formula in Excel.
1. Press Alt + F11 keys to open the Microsoft Visual Basic for Applications window.
2. In the Microsoft Visual Basic for Applications window, please click Insert > Module. Then copy and paste the below VBA code into the Module window.
VBA code: Highlight all cells referenced by a formula in Excel
3. Press the F5 key to run the code. In the popping up Kutools for Excel dialog box, please select a formula cell or multiple formula cells which you need to highlight referenced cells based on, and then click the OK button. See screenshot:
Now all referenced cells based on the selected formula cell(s) are highlighted in red immediately as below screenshot shown.
Related articles:
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by80%
Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
More than300 powerful features. Supports Office/Excel2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features30-day free trial.
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
Open and create multiple documents in new tabs of the same window, rather than in new windows.
Increases your productivity by50%, and reduces hundreds of mouse clicks for you every day!
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
That was really helpful. One additional question. Could someone tell me how to adjust the code, such that ONLY the blank referenced cells are highlighted and not all of them?
To post as a guest, your comment is unpublished.
That was really helpful. One additional question. Could someone tell me how to adjust the code, such that ONLY the blank referenced cells are highlighted and not all of them?
To post as a guest, your comment is unpublished.
Really liked it! But just one thing -- colon should be taken care of separately since it refers to a range.
MS Excel XP: What is the keyboard shortcut to highlight a cell? My searches turn up no answers. posted by bigmusic to Computers & Internet (8 answers total)
When you say highlight a cell, do you mean to select it or to fill it with a color or perhaps something else? If your cursor is on the cell, it is selected, and therefore options like CTRL B will bold the contents. More than one cell: hold down SHIFT & ARROW KEYS. My apologies if I've been too dense to understand your question. posted by b33j at 12:45 AM on July 8, 2006
F8? That highlights a cell. posted by zabuni at 1:41 AM on July 8, 2006
I, like b33j, don't understand what you mean. For me F8, turns on selection extension mode, but you don't need to do that if you are already on the single cell you want selected. If you actually mean to fill the cell with a color, then I don't think there is a built-in shortcut for that. You can make a macro by selecting Tools > Macro > Record new macro. posted by grouse at 2:04 AM on July 8, 2006
I think he means pressing a keyboard combination like +A+5 to zip straight to a particular cell w/o mouse or arrow keys (in this case, A5, of course). I'm not sure this is possible. posted by IronLizard at 8:37 AM on July 8, 2006
Err, there should be (somekey) in front of a+5, but I used angle brackets (oops). posted by IronLizard at 8:38 AM on July 8, 2006
I just wanted a shortcut to fill a cell with a color. Recorded the macro, it works quite nicely. posted by bigmusic at 10:46 AM on July 8, 2006
Not exactly a shortcut, but this is what I do to make filling a cell with color easy: Arrange the primary toolbar so that the 'fill cell' button is on the far left side. So, to the left of the new file and save file buttons (I do this with the formatting functions for which I don't have a shortcut macro--just fill cell and indent). Then to access, hit 'alt' to get to the menu bar, then 'ctrl-tab' to skip down to the first toolbar. The first button will be hightlight, so if that's the fill cell button, just use the arrow keys to select a color then hit enter. If fill cell is not the first button, you can tab to it. posted by mullacc at 1:57 PM on July 8, 2006
Ctrl-1 -> Patterns posted by baylink at 7:42 PM on July 10, 2006
« Older Help me call and surf for less | multi user web calendar Newer »
This thread is closed to new comments.
Need some pointers on creating a simple inventory...February 22, 2012 tips or tricks for organizing information using...April 8, 2009 How do I get Word and Excel to work together?February 5, 2009 Excel dragging other files into the party...July 15, 2007 MS Word help wantedAugust 4, 2006