Fault is not important when you are having problems… getting it fixed is. On Site Support HARDWARE & SOFTWARE We have found that most customers are tired of the excuses from ICT vendors… “… it’s the softwares fault” “…it’s Dell’s fault”.Office365 & Azure Help Help with Office 365 Issues.Windows 11 10 8 7 & XP Windows 2000, XP, Vista, 7, Windows 8 and more How Tos.Other Technologies Other Technologies like firewalls, VoIP, Skype, Hardware Comparisons and other how tos.Microsoft Exchange Server Exchange 2003, 2007, 2010 how to and demos.Mobile: Android, Samsung, LG Blackberry, BES, and BIS news and how tos.Office: Word, Excel, Outlook… Office Apps like Word, Excel, Visio, Outlook, Project, Powerpoint, 2003, 20.Microsoft 365, Azure & Hosting Help with Office 365 Issues.Windows Server windows 2003, 2008, R2 how tos.Windows 11 10 8 7 & XP Windows 2000, XP, Vista, 7 and more How Tos.You can also use Paste Special to paste the raw data with or without any formatting to have your information ready for reporting or plotting onto a chart.

The data pasted is only the grouped totals and not the underlying or hidden data. Select the data in its grouped state as below:Ĭlick on the Select Visible Cells command in your QAT to only select the visible data, use Ctrl + C to copy the data to memory and then go to the sheet where you want to paste the data and use Ctrl + V to paste the data: The command should now be available in your QAT on the top left of your screen. Click on Add to add it to your QAT and click on OK and OK. Press S on your keyboard to jump to all commands beginning with 'S' and search for Select Visible Cells. Once the box below has opened, select All Commands from the first dropdown menu on the left side of the window. Go into the Customise Toolbar by clicking on the dropdown menu next to your Quick Access Toolbar and selecting More Commands. Firstly, we will need the command adding to the Quick Access Toolbar to 'Select Visible Cells'.

Excel 2016 select visible cells icon