I'm going to select all of it, 'Control A' grabs my whole bit of data. You can unfreeze it by going to 'Unfreeze Panes'.Īnother handy cheat sheet for working with this type of data. This means, when I scroll down, hey, look at that, stuck at the top. So what we can do is, go to 'View', 'Freeze Panes', and here I'm going to freeze the top row, you could do the first column. It jumps me all the way to the end of that column, but wouldn't it be handy if I had myheader rows along the top here, because I have no idea what maybe this number is while I'm all the way down there. I can double click thebottom of any cell. One is, I'm working on this long document, it's pretty long. So I'm using my 'Control' 'Tab' again to jump to my next open Excel document. Just hit 'Control' ' ' and it's put in my exact today's date. Next shortcut is, say the date, you want to enter today's date. So if you've got a couple of thoseyou're copying and pasting from, 'Control' 'Tab' between the two. And I'm going to click that, and it toggles between any open Excel files. Normally, just above caps lock, on the left. Next shortcut is 'Control', and then 'Tab' on your keyboard. Click 'OK', and it's going to make it a pretty little table for me. Let's go and set it into a cool little- under 'Home', along here, where it says 'Format as Table', I'm going to pick one of the pre-defined ones. Just hit 'Control' 'A', and it selects the whole thing. Yours might be huge, lots and lots of rows and columns. Next step is, say you want to select the whole bit of data that you've got. Mine's set to £s at the moment, yours might be $s. And that will put it to your default currency. So, 'Control', 'Shift', and hit '4' on your keyboard. Next cheat is, selecting all these, I want them to be currency because pretty much they're always a currency in Excel. If I type in 'Monday', or 'Mon', and I drag it out, it puts in the days of the week as well. That works the same for days of the week. And if I grab the bottom right square, and drag it across, Excel's pretty clever, and knows I mean this string of dates.
Next tip, I'm going to type in 'January', or just 'Jan'. It allows me to put in either the rows or the columns. I need to add my headers, so I'm going to click in this top row here, and go 'Control', Shift', and hit '+'.
So the first tip from our cheat sheet is to insert a column. Check out my full Excel course on īefore I forget, there's also a printable PDF version that you can print off, and stick next to your desk, and look all awesome. And this is our Microsoft Excel 2016 cheat sheet.
0 kommentar(er)
