EB Excel

If you've got a large table of data, applying filters can help you to sort or hide data based on a number of criteria: Just select the headers of your table and apply the filters as below. #Excel #Support #Tips

Excel recently updated (unless you're using an old version!). It looks a little different now but don't worry, it all still works the same! #Excel #Support

Be careful when deleting a sheet in Excel. You can't undo the action so you can lose all your data. Our best advice if you do is to exit without saving and then reopen the spreadsheet. #Excel #Support #Tips

Got any questions about Excel that you want answering? Just get in touch and we'll help you out! #Excel #Support #Tips

Sometimes there's really silly things that go wrong and you can't work out why. Like the data in your cell not appearing. It's happened to us before. The text was coloured white! So just change it to back to black and you'll see it again! #Excel #Support #Tips #Errors

You can't name a sheet 'History' in Excel. You'll get this error message. We won't bore you with the details why though! #Excel #Support #Facts

That feeling when you've written a huge macro to automate a manual process for a client. And it works. #Excel #Support #Automation

Want to prevent anyone from editing your spreadsheet? You can use the 'Protect Sheet' function found under the 'Review' tab. You can also set a password to make it even more secure! #Excel #Support #toptips

Don't forget, Excel has the 'Undo' function so you can reverse that mistake you just made. Realised you've made a lot of mistakes? Well you can Undo the last 100 you performed! And the shortcut is Ctrl + Z #Excel #Tips #Support #MondayMotivation

You can now cheat to create Pixel Art in Excel! Matt Parker found a way to convert images into spreadsheets. You can upload an image here: think-maths.co.uk/spreadshee… and it will give you an Excel file with each cell representing a pixel! #Excel

Got any burning Excel questions that you need answering? Or just wondering if it's possible to do things more efficiently? Get in touch and we'll help you out. #Excel #Support

Did you know, each Excel sheet has 17,179,869,184 cells. If you spent 1 second filling in 1 cell, it would take you 545 years to complete the entire sheet! (It's a good thing Excel has many ways of automating tasks!) #Excel #Support

Having issues printing your Excel spreadsheet? You can use the 'Scale to Fit' section under the 'Page Layout Tab' to tell Excel how many pages to fit it onto. If you change the Width and Height both to 1, it will print your entire spreadsheet on 1 page! #Excel #Support

Did you know you can use the 'Clear' button to do the following in a cell: Delete the contents but keep the formatting Delete the formatting but keep the contents Or just delete everything in there! #Excel #Tips #Support

The saying that we always use is "You don't know what you don't know". Excel has so many cool functions that can speed up your tasks. Why not get in touch to see if we can help! #Excel #Support

How's this for a mini office building that someone made in Excel. It must have taken a long time to colour in all those cells! #Excel #pixelart #Support

Trying to put a phone number into Excel and the leading zero disappears? Change the format of the cell to 'text' and it will keep it in. #Excel #Support #PhoneNumber #Formatting

Did you know you can select every cell in a spreadsheet with one easy click? Just click on the little square with a triangle left of Column A and above row 1! #Excel #Tips #Support

Have you spent ages on a spreadsheet and then realised you've made a spelling mistake repeatedly?!? Worry not, you needn't manually go through changing everyone one, just watch this short video on how to fix it! #Excel #Support #FindandReplace #Spelling