Microsoft Excel Favorite Tip.
Today, October 17, 2022 is International Spreadsheet Day. Microsoft has asked a lot of creators to post their favorite Excel tips. Here is mine: Double-click the Fill Handle to copy a formula to the bottom of the data.
How to copy Excel formula to the bottom of the data set by double-clicking the Fill Handle.
LC has 4000 rows of Excel data. After every two rows, he wants to insert a blank row. How can he quickly insert 2000 blank rows in the data? My solution today involves a formula to create alternating cells with text and numbers. Then Home, Find & Select, Go To Special. Select all Formula cells that result in Text. This selects every other row. You can then Insert Sheet Rows and you are done in less than 60 seconds.
Excel Mystery: Someone reports they have 7 cells with data. One of them has a mystery line at the bottom of the cell. It is not a border. What else could it be?
Keith wants to use the Excel FILTER function to get all names where two conditions are true: Status is A and the Project does not start with 22-05. This video shows how to combine 2 conditions in an Excel FILTER formula.
excel filter function
why excel filter not working
excel can you filter columns
excel can you filter with LEFT
excel can you filter to two conditions
How to add a watermark in Excel?
Table of Contents
(0:00) Start with a watermark image with white space above.
(0:39) Adding image to Excel header.
(1:25) Adjust Transparency.
(2:10) Using a picture as a Watermark.
(2:40) Creating a Confidential Stamp to Use in Watermark.
(4:29) Bending text in WordArt.
This video is created for these popular Search terms:
how to add image as watermark in excel
how to add watermark image in excel sheet
how to add picture watermark on excel file
how to add watermark picture in excel
how to make watermark background picture in excel
how to put watermark picture in excel
can you add a confidential watermark to excel
how to add Continue reading “Excel Add Watermark to Excel – 2581”
Colleen calls with a question today. She has a pivot table with too many fields in the Values area. She can’t easily resequence them. Is there a way to see more fields in the Pivot Table Fields pane?
Table of Contents
(0:00) Areas Section Only
(0:12) Undock & Resize Field List
(0:22) Drag line between Fields & Areas
(0:29) Re-dock pivot table fields pane
(0:39) Dragging field headings in pivot table
(0:50) Rearrange by typing
Shoutin’ Sam has an Excel question.
This video shows many ways to answer different questions.
=FILTER() in Excel
=XLOOKUP in Excel
=TEXTJOIN in Excel
=INDEX(FILTER()) in Excel
Microsoft Excel started showing an outline around the formula bar, when you are editing a formula in the formula bar.
Why is there a thick dark box around the formula bar in Excel?
Or, have you never noticed it?
It is part of the F6 Loop.
Microsoft fill cells with numbers 1 to 100,000.
YouTube viewer asks: How to generate numbers 1 to 100000?
There are many ways to do this in Excel. I will show you two methods in this short video.
Two ways to calculate a running total in Excel.
The first method is the sum of the cell in this row and the running total from above.
The second method is an expanding dynamic range.
This video answers these common search terms:
Calculate Cummulative Sum In Excel
Excel How To Do A Cumulative Sum
How To Add Cumulative Sum In Excel
How To Calculate A Cumulative Sum In Excel
How To Calculate A Running Sum In Excel Table
How To Caluclate A Cumulative Sum In Excel
How To Create A Cumulative Sum In Excel
How To Create A Running Sum On Excel
How To Create Excel Running Sum
How To Cumulative Sum Continue reading “How to Do Running Total Sum in Excel #shorts”
How to use the AutoSum when you need to sum non-contiguous cells in Excel.
This video was created to answer these search terms:
How To Sum Non-Contiguous Cells In Excel?
How To Sum Specific Cells In Excel Formula
How To Count Sum For A Particular Cell In Excell
How To Count Sum Of Certain Cells In Excel
How To Select Cells In Excel For Sum
How To Sum Certain Cells In Excel
How To Sum Different Cells On Excel
How To Sum Different Columns In Excel
How To Sum Different Rows In Excel
How To Sum Select Cells In Excel
How To Sum Two Cells In Excel
Carl Pepperseed, on assignment in the Burmese Jungle, reports that his =IMAGE() function in Excel suddenly started returning a #CONNECT! error. While we all feel bad for Carl, maybe that means that IMAGE is now Dynamic? If we could just figure out what Carl did to bring that #CONNECT! error!
How about F9? No.
How about Ctrl+Alt+F9? No.
How about F2 / Enter? No.
Replace the URL and then Undo? The image is still there.
Copy the sheet within the workbook? No.
How about Copy the Sheet to a new Workbook? That seems to be it.
Which is bad news for the people hoping for Dynamic Continue reading “#Excel Why IMAGE Function Changes To CONNECT Error #shorts”