The data will be pasted into the space, with the other columns/rows automatically shifted so that you don't leave an empty space in the worksheet. Now tap on the column to the right of, or the row below, where you want to paste the data and press Insert Left or Insert Above. Trying to manually select all the data in a long row or column might be awkward on an iPad, but there's a much easier way to do it.Ĭlick on the column/row's number or letter and the entire column/row will be highlighted. Sometimes you might find you want to move the contents of an entire row or column to a new location.
Click that and drag the arrows that appear on your selection either downwards or sideways to Autofill the contents. Then a pop-up menu will appear, with Fill among the options. On the iPad, you first need to select the cells in question, by clicking on the first cell and then dragging the little circular handles down to the last. In the desktop version of Excel, Autofill is activated by clicking on the bottom-right corner of a selected cell and dragging downward/sideways. With Autofill you can type "Monday" and "Tuesday" in successive cells, and then drag down to Autofill the next five cells with the remaining days of the week. So, for example, if you've got a spreadsheet analysing daily sales figures, you might have the days of the week running down a column. It spares you from laborious entry of text or formulae by second guessing what you want to appear in the column or row. Then if you make any mistakes, you've got the original to fall back on, without having to rely on the Restore function.Īutofill is one of the most useful features of Excel on the desktop. If you're planning to work on a complex spreadsheet on the iPad, it's best to click the Save menu button (the little page icon with the two arrows) and click Duplicate before you get going. The undo button in the top left corner can come to your rescue if you notice your mistake, but it's easy to damage something without noticing, and because the app is set to autosave by default. If you're working on a spreadsheet created on a PC/Mac that has tons of formulae, pivot tables or other complex formatting, it's possible to accidentally clear the contents of a critical cell or drag a table out of place as you're swiping around the document. Duplicate before doing anything complexĮxcel for iPad can be too powerful for its own good. However, users should be aware that after the first 30 days, you'll need an Office 365 supscription to do anything more than view spreadsheets with the iPad Pro. In addition to a larger screen surface to work across, the addition of the Apple Pencil and Smart Keyboard means that users can have much more delicate control of their spreadsheets, without worrying about deleting something vital with one ham-fisted swipe. Work on more cells at once with the iPad ProĪpple's mammoth 12.9in tablet has been touted for its use as an enterprise prodcutivity tool, and so it's no surprise that Microsoft has brought out a special version of its app to take advantage of the iPad Pro's larger screen. Here are our top 11 tips to get the best our of Excel on your Apple tablet.
#USE EXCEL FOR MAC TRICKS FULL#
Despite lacking a full keyboard and mouse interface, Excel for iPad is very nearly the equal of its desktop counterpart. Sure, you can go back and click every cell to see them, but if you hit Ctrl and the tilde key, all your formulas will be revealed in their cells.It's been two years since Microsoft launched Excel for iPad, and while it may have seemed like a slightly foolhardy move at the time, Apple's tablets have proved themselves to be more than capable of handling complex spreadsheet manipulation. But sometimes you need to check those hidden formulas. Once that's done, the underlying formula becomes hidden from view. Normally, you enter a function either in the formula bar or directly in the cell, and - when you hit enter - it displays the result.
They are math equations that Excel computes and displays. Ctrl-Shift-Semicolon inserts the current time.įunctions are the math formulas that give Excel its power. In my mind, it stands for Express Delete.Ĭtrl-Semicolon inserts today's date. When you want to fully delete a cell, you can certainly right-click and then hit delete, but I find it faster to keep my hands on the keyboard rather than going for the mouse. (Note: the "0" is the number zero, not the letter O.)
Here's the shortcut for that: select the column you want to hide, then hit Ctrl-0. Sometimes, you just want to hide some data without deleting it. Instead of scrolling, Ctrl-Home takes you back to the first cell: A1. And if you want to select a single row, use Shift-Spacebar.īig spreadsheets can be many pages long. You probably know that Alt-a will select everything on a page, but if you simply want to select one column, hit Ctrl-Spacebar.
0 kommentar(er)
