Helen Bradley - MS Office Tips, Tricks and Tutorials I'm a lifestyle journalist and I've been writing about office productivity software for a long time. Here you'll find handy hints, tips, tricks, techniques and tutorials on using software as diverse as Excel, Word, PowerPoint, Outlook, Access and Publisher from Microsoft and other applications that I love. My publishing credits include PC Magazine, Windows XP mag, CNet, PC User mag, SmallbusinessComputing.com, Winplanet and Sydney Morning Herald. One of the most difficult things that people find with working with columns in Word is moving between the columns. The reason is that the process itself is anything but easy. The Tab key, which will move you between cells in columns in a table, doesn’t work inside newspaper style columns in Word so that key is out. Playstation video app for mac. Jump to Columns - Columns. When creating columns, always use true columns, not columns created by hand with the Tab key. Instead, to move or jump from one column to the next you’ll press Alt + Page Down to go to the column on the right (the second column) or Alt + Page Up to move to the first column. When you click Alt + Page Down, if you are in column 1 you’ll go to the very top of column 2. If you keep pressing the key you’ll flip between the top character in each column. If you’re somewhere in column 2, when you press Alt + Page Up you’ll go to the top of column 1. These are the only specialist keys for moving or switching between columns – we could use more – like jumping from a line in one column to the same line in the one next to it – but nada! By: We recently wanted to insert some data from Excel into a Word document, but needed to be able to update the Excel data while we worked on the project. There was no easy explanation of how to do this in Help, or online, so—we created our own. This tutorial demonstrates how to place linked Excel Files into Word documents, while enabling the Excel files to be updated independently of the Word document. Note that you have to be careful when utilizing this process by ensuring that the numbers in the Excel portions of the document are correct before deciding that the document is final. Since you will be linking files together and Microsoft Office relies on to files, it is important that you have your files in a FINAL location, which will not change as you work. If files “get lost,” it is possible to relink them, but it’s best if all the files you’re using are in a single folder. It’s even better if you do no intend to move the folder later (note: this is largely to facilitate your ability to relink the files later if the links get broken). I have tested this, and even after moving the main folder, the files still “worked,” but it’s best to be cautious. In my testing, Excel seems to require all the linked spreadsheets to be open in order for everything to update correctly. I’m sure there is a way to link them more robustly, but have yet to find it. So, until it is found, you will need to open all the spreadsheets that are cross-linked in the document and then update them as necessary. Note: DON’T attempt to open all the files independently, at the same time. If you need to work on the Word doc and the Excel docs simultaneously, then open Word first and use it to open the Excel files as shown in the step below. Note that you CANNOT simply type new numbers into the tables of the Word document and expect them to be updated in Excel. You CAN type new numbers, but they become “dead.” To update Excel from within the Word document, right click on the table and choose Linked > Open Link (as shown above). The Excel file will open in Excel where you can edit directly. Changes that you make will show up immediately in Word FOR THE CELLS YOU ARE EDITING ONLY. If there is cross-linking between spreadsheets, then the linked data will not be automatically updated. Save and close the Excel sheet when you are done editing. You can convert the Word document to a finalized version by breaking all the links. First, select Edit > Links from the Edit menu. Next, select all the linked Excel sheets and choose the Break Link button. This will break the links to the Excel docs so that new changes will never get included in the Word document (note that the numbers in the Word document can still be edited manually).
0 Comments
Leave a Reply. |