You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
Okay, you’ve got data arranged in spreadsheet rows and columns, with column headers. So why try tables?
Well, tables make it easy to format data, sort, filter, add totals, and use formulas. With tables, you don’t need to fuss to get formatting just right. Excel automatically adds formatting that makes tables stand out from any other data on your spreadsheet. And if you don’t like the formatting you see at first, Excel has many table formats to select from.
Tables automatically come with drop-down arrows at the top of each column that you can use to sort and filter.
Today's blog post on repairing numbers that are formatted as text is brought to you by Gary Willoughby, who writes Help content for Microsoft Excel.
A few months ago, my new manager e-mailed us (that is, her team of Excel writers). She had a spreadsheet with some columns of numbers that she wanted to total, and the answer was resolving to 0. When you have lots of values in a column and their total is 0, you have a problem: Those numbers may not be numbers at all! (cue the scary music).
Keep reading to learn how to solve this common problem.
Keyboard shortcuts....You use them every day to make your work flow smoothly, or - in some cases - to make your work flow, period. In all honesty, I use some of them so often that I have no idea where to find those functions on the ribbon! (Copy? Paste? Undo? I haven't done those with a mouse in YEARS!) And I know I'm not alone. In the content that I manage, it is THE most popular subject, and generates the most feedback, with Excel users leading the charge.
So, in response to an overwhelming number of requests from you, Excel users, I've created some Quick Reference Cards - sheets, really - that you can download and save, or just print and keep near your workstation. Keep reading to learn how to access this new resource.