New in Office Excel, Word, and PowerPoint. Right-click any object and choose Save As Picture. This feature seems so natural, it is hard to believe it has not been there for decades. Same SmartArt as a picture. Save a chart as a picture. Save Cutout Randy as a picture. Also in this episode, using a Linked Picture to be able to save part of the grid as a picture.
Sowmiya needs to highlight entire row with highest value with different data sets.. for eg coulmn A having id numbers , id 1 and 2 etc.. column b having lead count.. coloumn C having dates. Id1 taken lead count 6, 9 , 10 in different dates.. id number 2 having lead count 15 , 10 , 9 in different dates. I need to highlight unique highest values for each id. Output I need is to highlight the row id1 against lead count 10 and id 2 against 15 which is the highest value
A question from Foxy on YouTube: What Excel formula will convert a date to the Week Number of the Month? It should never show more than a max of 5 weeks. Download the practice file: 2350_Practice_File.xlsx
Siva has a cell with comma delimited numbers. How can you add 500 to each number in the cell? In this episode of the Dueling Excel podcast, Bill uses a tiny VBA macro from Excel MVP Brad Yundt. Mike builds a killer formula using the LET function in Excel.
For my Excel friends, try out our new captions in 20 languages.
For YouTube Creators, here is how we are creating captions. How does this compare to your method?
We find that the Google Translate API works far better than the YouTube Automatic Subtitles. Both processes are owned by Google. Why doesn't YouTube use the better algorithm from Google?
Rob on Twitter asks: If I'm using a table, and one of the columns has a formula in it, is there a way to automatically include that formula when I insert a new row? In episode 2349, I show two different ways that this *should be* working and a couple of things that could cause it to break.
Just like the Guess Your Age booth at the Carnival, Excel can guess your age from your given name. In episode 2348, we will take a look at the Wolfram Alpha data types for Given Name, Fictional Character, Amusement Parks, Notable Texts, and Authors.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.