MrExcel Excel Videos

excel how to unhide top row how do i unhide row 1 in excel how do i unhide rows at top of excel sheet how do i unhide rows in excel that are at the top how do i unhide the first row in excel how do i unhide the first row in excel? how do i unhide the top rows in excel how do i unhide top rows in excel how do i unhide top rows in excell how do you unhide first rows in excel how to unhide a top row in excel how to unhide first row in excel how to unhide first rows in excel how to unhide row 1 in excel how to unhide row a1 in excel how to unhide rows 1 and 2 in excel how to unhide rows at the top of excel how to unhide rows at the top of excel sheet how to unhide rows at top of excel how to unhide rows at top of excel sheet how to unhide...

How to unhide a specific row in Excel. can you unhide a specifc row in excel excel how to unhide a specific row how do you unhide specific rows in excel how to unhide a specific row in excel how to unhide certain rows in excel how to unhide selected rows in excel how to unhide some rows in excel how to unhide specific rows in excel how to unhide a few rows in excel how to unhide a group of rows in excel how to unhide a range of rows in excel

Short video showing how to unhide all rows in Excel. excel how to easily unhide all rows excel how to unhide all columns and rows excel how to unhide all rows in one excel how to unhide all the rows how can i unhide all rows in excel how can you unhide all rows in excel how do i unhide all rows in excel? how do i unhide all rows on excel how do i unhide row all rows in excel how do you unhide all excel rows and colums how to get excel to unhide rows at once how to quickly unhide all rows in excel how to unhide al rows in excel how to unhide all rows in excel how to unhide all columns and rows in excel how to unhide all hidden columns / rows in excel how to unhide all in excel row how to unhide all of the rows in excel how to unhide all...

Kara asks: Do you have a trick for the subtotal function? In a "subtotal by" task where I use three fields (ID / Name / Amount) to get the total amount, Excel makes me choose between ID or Name for "at each change in" but I'd like to retain both so I currently perform data gymnastics to concatenate the ID and Name fields.....and then after using the function, I perform more gymnastics after selecting level 2, "go to special" / visible cells only on the subtotals, paste to another sheet, and then split the ID and name back out with the subtotaled amount. This is way too many steps!! I have two solutions in today's video: 1) Subtotal by ID and use Select Visible Cells to pull the Name down into the subtotal row 2) Use Excel Power Query...

Rich needs to VLOOKUP into data with " Total" after the tracking number. When he tries to Replace " Total" with "", Excel converts the tracking numbers to scientific notation. When he tries to convert everything to numbers and I lose the last several digits when they change to 0000. In today's video, a new option in Microsoft 365 beta to prevent the conversion to scientific notation. And then a way to hack the VLOOKUP formula. Table of Contents (0:00) Copy subtotals in Excel (0:36) Replace in Excel converts to Scientific Notation (0:54) Long numbers in Excel last digits change to zero (1:09) Beta option to prevent Data Conversions in Excel (1:49) Hacking VLOOKUP to add Total for subtotal rows

Today, a great idea from Yure in Brazil. He is using concatenation inside the HYPERLINK function to create a MailTo hyperlink. Click the cell in Excel and your e-mail program opens with the Recipient, Subject, and Body already filled in. However... it the hyperlink grows to more than 255 characters, we are getting a #VALUE! error instead. Can you go and vote to ask the Excel team to increase the limit for the HYPERLINK function: Community In the meantime, you can use VBA code from Ron De Bruin to send e-mails from Excel. See his code at: Mail from Excel and make/mail PDF files (Windows) Who remembers the time that Kelly Rowland used Excel to SMS Nelly? Here is a link to that music video. Table of Contents (0:00) Sending e-mail from...

Mapping Census Tracts in Excel. Excel supports mapping by county, zip code, state, country. But they don't natively support census tracts. In today's video, you will see how to download population data and a map KML file from Census.Gov. Learn how to import the KML file into the 3D Map feature in Excel and make a map from it. This video also covers: Downloading a CSV with population by census tract from Data.Census.Gov. Downloading a KML file by Census Tract Importing and merging that data in Excel. Table of Contents (0:00) Excel Mapping Other Jurisdictions (0:51) Four Video Sections (1:19) Examining KML File in Notepad++ (2:14) Opening 3D Map (2:54) Importing KML to 3D Map (3:30) Adding KML Field to Map (5:06) Getting Population by...

Harsinchh asks if there is a way to highlight all formula cells and the precedents of those formulas. There are a lot of techniques discussed in this video: Show Formulas in Excel Select all Formulas in Excel Go To Special Precedents in Excel Direct versus All Precedents in Excel VBA to select formulas in Excel VBA to select precedents in Excel VBA to union two ranges in Excel Table of Contents (0:00) Excel: Select Formulas & the precedents (0:25) Excel Show Formulas (0:55) Selecting all Excel Formulas (1:16) Selecting Formula Precedents with Go To Special (1:40) All Precedents versus Direct Precedents (2:52) Four-step is a kludge (3:08) VBA Macro to select formulas and precedents (4:49) Personal Macro Workbook

Ozveri is wondering why the Excel Filled Map Chart shows the entire world when he has just a few countries around the Mediterranean Sea. It is an annoying part of Excel Filled Map Charts. But there is a solution. It is buried where you will never find it. Format the data series in Excel and choose Only Regions with Data. Also in this video, I show you how to create a tiny macro in your personal macro workbook that will quickly change this setting. The macro from 3:00 minute mark: Sub ShowOnlyRegionsWithData() ' ShowOnlyRegionsWithData Macro ActiveChart.FullSeriesCollection(1).GeoMappingLevel = xlGeoMappingLevelDataOnly ActiveChart.FullSeriesCollection(1).RegionLabelOption = xlRegionLabelOptionsShowAll End Sub Table of Contents...