Month: April 2023

Excel Too Many Fields In Pivot Table Field List To Move Around Easily #shorts

Posted on by Annie D

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

Excel Add Watermark to Excel – 2581

Posted on by Annie D

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” →

Excel Challenge How Did Bill Manage To BREAK The Excel Status Bar Sum #shorts

Posted on by Annie D

There was a scary post online today… the Excel Status Bar sum was WRONG! But it is not wrong… it is a great trick that will win you bar bets from your Excel guru friends!

The Status Bar sum is CORRECT when you select from bottom to top!
But it is INCORRECT when you select from top to bottom!

Down in the YouTube comments, tell me how I managed to do this.

It required no VBA. You can easily do it yourself and freak out your Excel guru friends!

Don’t feel bad… when I first saw it, I could not figure it out Continue reading “Excel Challenge How Did Bill Manage To BREAK The Excel Status Bar Sum #shorts” →

#Excel Why IMAGE Function Changes To CONNECT Error #shorts

Posted on by Annie D

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” →

Excel How to Sum Non Contiguous Cells #shorts

Posted on by Annie D

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

How to Do Running Total Sum in Excel #shorts

Posted on by Annie D

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 Create a SUM in Excel #shorts

Posted on by Annie D

How to create a SUM function in Excel.

This answers these search terms:
Autosum A Column In Excel
Excel Easy Way To Sum
Excel How To Add Sum Of ”
Excel How To Create A Sum Formula
Excel How To Use Autosum
Excell How To Make The Sum
Formula To Add In Excel Sum
Hhow To Use Sum In Excel
How Do I Add Cells In Excel For A Sum
How Do I Create A Sum Formula In Excel
How Do I Do A Sum Formula In Excel
How Do I Do Sums In Excel
How Do I Get A Total Sum In Excel
How Do I Insert The Sum Formula In Excel
How Do I Continue reading “How to Create a SUM in Excel #shorts” →

How to Get the Sum At the Top of Excel #shorts

Posted on by Annie D

How to get the sum at the top of Excel?
This short video shows two methods:
Add the sum at the bottom and then Cut using Ctrl+X and paste at the top.
Or, start at the top, click AutoSum, and then select the range of numbers with the mouse.

How To Get Sum At Top Of Excel
How To Sum At The Top In Excel

How to Make a Sum Negative in Excel #shorts

Posted on by Annie D

How to make a sum negative in Excel.
You have a sum in Excel but want a minus sign in front.
When you total checks, how do you make the sum negative in Excel?

This video answers these common search queries:
How To +/- A Sum In Excel
How To Do Minus Sum In Excel
How To Do Minus Sums On Excel
How To Make A Sum Negative In Excel
How To Make Sum Negative In Excel
How To Minus A Sum On Excel
How To Put A Total Sum As A – In Excel
How To Put A Total Sum As A negative In Excel
How To Put A Total Sum Continue reading “How to Make a Sum Negative in Excel #shorts” →