• Home
  • Knowledge Base
  • Blog
  • Latest comments
  • Tools and resources
    • Password generator
    • What is my IP?
    • Who is – domain name info
    • Screen colour picker
    • How to convert to MP4 and compress videos
    • WCAG Colour Contrast Analyser
  • About

IT Support Guides

  1. Home
  2. Knowledge Base
  3. Excel 2016

Excel 2016 – How to delete empty rows

  • 2

Excel 2013/2016 – How to change CSV delimiter character

    Excel 2016 – How to delete all empty columns

      Excel 2016 – Auto-sum not working until edit formula or save spreadsheet

        Excel 2013/2016 – How to split comma separated values into columns

          Excel 2016 – Formula to calculate age group from age

            Excel 2016 – How to exclude (blank) values from pivot table

              How to create named cell references in Excel 2016

                Excel 2016 – What is #DIV/0! error and how to fix it?

                  Excel 2016 – How to filter pivot table data

                    Latest Articles

                    • How to replace character with new line using Notepad++
                    • SQL – How to copy column data to another column
                    • How to specify Facebook link image without using OG:IMAGE
                    • jQuery – How to automatically display images with caption
                    • Excel – How to convert negative/positive numbers

                    Recommended

                    Knowledge Base Categories

                    • WordPress
                    • Windows XP Tips
                    • Windows 8
                    • Windows 7
                    • Windows 10
                    • Website Tips
                    • VBS Scripts
                    • Uncategorized
                    • Ubuntu
                    • Technology Tips & Tricks
                    • SQL Server
                    • Server stuff
                    • Server Side Tips
                    • QGIS
                    • Online marketing
                    • Office 2016
                    • Office 2013
                    • MySource Matrix
                    • Microsoft Office 2010
                    • Microsoft Office 2007

                    Tags

                    Adobe Acrobat Adobe Reader CMD ConfigMgr Crystal reports Excel 2013 Excel 2016 Facebook File Explorer Firefox Google Google Chrome Gravity Forms htaccess iPad iPhone iPod jQuery Microsoft Office 2010 Office 2013 Outlook 2010 Outlook 2013 Outlook 2016 PDF PHP phpMyAdmin SCCM Search Silent install SQL SQL Management Studio SQL Server T-SQL TinyMCE TSQL Twitter Ubuntu VLC Media Player Windows 7 Windows 8 Windows 10 Word 2013 Word 2016 WordPress

                    Latest comments

                    • Chris Pink Change this: $apply_column_position = 2; to this $apply_column_position = array (2,3,4); and then 7 lines down change this; if ( $text == $choice['text'] && i$column_position ==...

                      Gravity Forms – How to add checkbox option in list field ·  one week ago

                    • raf Hello all,Try this in your WQL queryselect SMS_R_System.NetbiosName, SMS_G_System_PRINTER_DEVICE.Name, SMS_G_System_PRINTER_DEVICE.DeviceID, SMS_G_System_PRINTER_DEVICE.DriverName,...

                      ConfigMgr Reporting – List all printers (local and networked) ·  one week ago

                    • John Schuyler Nice, thoughtful, careful procedure posting. However, it's not working in the current (Aug 2018) version of MSO Office 365 Business. I restarted word, opened a new document, inserted 12rx4c blank...

                      Word 2013 & 2016 – Table ‘repeat header row’ not working  ·  2 weeks ago

                    • K JL I have a USB stick that i could still access but i couldnt delete anything off of it (i dont think it was dead), so I did this and I was able to clean my USB stick....however, now it cannot be...

                      Why USB flash drives “write protected” ·  last month

                    • John Bower thank you very much this worked spot on

                      Windows 7 – How to Open a .Pages Files ·  last month

                    Recent Posts

                    • How to secure your LastPass account and passwords
                    • Facebook HEARS everything?
                    • Why UX is more important than SEO
                    • Annoying web trends that need to stop
                    • Free stock images for your web design projects
                    • About
                    • Donate
                    • Privacy policy
                    • Copyright
                    © Copyright IT Support Guides