Tips for manipulating Excel 2007 and 2010

Excel is the most popular spreadsheet processing software available today because it addresses most basic and advanced needs. Besides equipping you with the necessary knowledge, the following article will provide some tips to help you work better on this powerful tool.

Extract content into image format

Do you have a chart on Excel or a table of data to extract out in image format to paste on text files, upload or share via email? Use the mouse to scan the block to extract, then click the arrow below the Paste icon, select As Picture / Copy As Picture . In the Copy Picture dialog box, select ' As Shown on Screen ', click OK , then you can paste (Ctrl + V) into some image editors or documents.

Update manual data

By default, when you want to change certain data in the spreadsheet, the relevant data will automatically change accordingly.

This is a very useful feature of Excel that makes spreadsheets always up to date. But for 'huge' spreadsheets with thousands of metrics, updating as soon as you enter it will take a lot of time, while you still have to import a lot of other data.

To turn off auto-update, go to the Formulas tab, then click on calculation options > manual . Later, when you have changed the necessary data, just press F9 to Excel update the relevant data.

Customize Quick Access Toolbar

Just like Microsoft Word, Excel provides users with a quick menu containing the most commonly used commands called Quick Access Toolbar . By default, this menu will only contain save, undo, repeat actions . You can customize it, put more frequently used tools into this menu to speed up the work.

To do this, in Excel 2007, click the Office button, select Excel Options > Customize . On Office 2010, select the file > Options > Quick Accesss Toolbar . Then select the usual tools that contain the left column and click ' add ', then click ' Ok ' to finish.

Change the input method

When you enter the data into the worksheet, by default when you press the Enter key, the cursor will jump to the next cell in the column.

If you want to enter data in a horizontal row, ie when you press Enter the mouse cursor will jump to the left or right pane, change it again by clicking on the Office button, select Excel Options or (with Excel 2010, choose File > Options , then click advanced and check on ' After pressing enter move selection ', in the drop-down menu, select the direction of the cursor you want to move.

Image compression

Images or graphic elements will greatly increase the size of document files, making it difficult to share online. So you need to compress it by clicking on the image you need to compress, on the toolbar you choose Compress Pictures , then click on the option in the Compression Settings dialog box to select compression purposes such as compression to print, compress to see through. projector or web, compressed to share via mail . Finally, click Ok to finish.

Create automatic data filling forms

AutoFill ( autofill ) is a self-input function that helps you enter data faster with drag and drop operation. Enter the first two values ​​in the row and column to set a 'rule', then click the right edge of the first cell to appear with a ' + ', then drag and drop to automatically fill in the numbers next.

You can add your own lists by going to File / options (in Excel 2010) or clicking the Office button, select Excel Options > Popular > Edit custome list . Here you can add lists in the form of sequences such as: spring, summer, autumn, winter or a number of rules.

Show / hide shortcuts

This is an interesting little feature in Excel 2007 and 2010. When you press the Alt key, the shortcut will appear right on the toolbar and correspond to each of those tools. To use it, simply press Alt + corresponding shortcut. This helps you not need to remember the keystrokes but can still use them to speed up your work.