Copy and Paste Visible Cells


You can copy and paste visible cells by highlighting the cells and then going F5 --> Special --> Visible cells Only

Then click copy and paste the cells in rows that are not filtered


Comments

Post a Comment

Popular posts from this blog

View Excel Workbooks and Formulas

Image
To view any excel workbook and the formulas within their cells, please click on the bottom right icon. Also, once I learned about the FORMULATEXT function so I starting utilizing that at some point so you can see the whole formula without having to click into a cell.  Note the following: 1) All numbers are made up; I often use the RANBETWEEN() function to randomize numbers. It allows you to restrict the randomized number with a min and max value. 2) On the Excel Blogspot article, you can utilize the dropdowns and filters. However, once you open he excel workbook with the bottom right icon, it no longer allows you that option. For example, look at the article below and try the dropdown and filters on the blogspot website vs. opening it in an excel workbook using bottom right icon. Article:  GETPIVOTDATA
Read more

Xlookup specific value in the middle of a string

EXCELIFSUN Credits goes to the YouTuber EXCELSIFUN. I was familiar with idea of using MID and XLOOKUP.  However, I liked how he pointed out by adding a zero, it can convert the text after using the MID function to a number so that we can use the xlookup. Also, if you highlight all the cells, then enter the formula in the first cell of the highlighted array, then Ctrl + Enter, you can autofill the formula throughout that whole array.
Read more

Power BI

Image
First of all, all credit goes to Linkedin Learning and Joshua Rischin, Company Director of Axium Solutions. I watched the video and followed along how to create a dashboard using Power BI. There is a title, a line chart, waterfall chart, and a slicer to filter for a specific state's sale on top right. Most notably, if I clicked on one of the bars on the waterfall chart, then it the line chart above will also filter for that specific product category. Please see Power BI screenshots below How it Looks in Power BI Exported into Powerpoint
Read more