You are viewing posts from the . excel tipsClick to view all posts
Written by Andy Trainer – Thu 29 Jan 2015
Use these step by step instructions to sort your lists with maximum efficiency in Excel.
Excel can sort columns into order alphabetically and numerically. You can perform a single column sort of multi column sort.
The Sort command can be found on the Home tab under the Editing group.
Important: When setting up the list, include a set of column headings (as example below). These are used to control the sort columns. The list must be sequential, i.e. no row gaps from the top of the list to bottom.
Click into a cell in the column that you wish to sort by, as in the example below the First Name column.
Select the Data tab, then to sort by A to Z or Z to A.
Written by Andy Trainer – Fri 19 Oct 2012
In this post I share three of my favourite Excel tips that - once you know how - become very useful. Most people who use Excel have only just scratched the surface, if you take the time to learn more about Excel, you could really achieve a lot more at work and at home. Learning Excel is time consuming, and a near impossible task to do on your own. We provide regular Excel resources and tips on the blog, but nothing beats hands-on, classroom based Excel training.
Here are three Excel tips that come in handy once you know what you're doing:
When you have a long list of data that stretches across the page it can sometime be difficult to read each line precisely across. One way to help you, and your eyes, is to make every other row a different colour.
ITIL®, PRINCE2®, PRINCE2 Agile®, MSP®, M_o_R®, P3O®, MoP®, MoV® courses on this website are offered by The Knowledge Academy, ATO of AXELOS Limited. ITIL®, PRINCE2®, PRINCE2 Agile®, MSP®, M_o_R®, P3O®, MoP®, MoV® are registered trade marks of AXELOS Limited. All rights reserved.