Highlight all columns you want to set to auto-fit the width. Go to Home tab, click Format under Cells section, and choose AutoFit Column Width. You can also use the AutoFit Row Height to auto-fit the height of the rows you highlighted as well. If you are using Excel to manipulate the data on. AutoFit Column Width Shortcut. Alt, H, O, I (PC) Action. Adjusts the column width to automatically fit the contents. Press and release each key in order, you don’t need to hold any of them while pressing another (First Alt, then H, then O, and then I). This shortcut is not available for the Mac version of Excel 2016. Open Drop-down Menu.
There are over 200 Excel shortcuts for both Mac and PC. This article is a quick run through about 50 shortcuts you should know. I hope you find a few that save you time today. Leave a comment below if I missed any you think should be in this list.
– Dave Next worksheet / Previous worksheet Often, you'll need to switch back and forth between different worksheets in the same workbook. To do this on the keyboard, use Control + PgDn (Mac: Fn + Control + Down arrow) to move to the next worksheet to the right, and Control + PgUp (Mac: Fn + Control + Up arrow) to move to the worksheet to the left. Next workbook / Previous workbook To rotate to the next open workbook, use the keyboard shortcut Control + Tab (both platforms). To reverse direction, add the shift key: Control + Shift + Tab. Expand or collapse ribbon This shortcut seems a bit frivolous until you realize that the ribbon is sitting there taking up 4 rows of space, even when you're not using it at all.
Use Control + F1 (Mac: Command + Option + R) to collapse the ribbon when you don't need it, and bring it back when you do. Display the Paste Special dialog box This shortcut, Control + Alt + V (Mac: Control + Command + V) doesn't actually finish the paste; it just opens the Paste Special dialog box. At that point, you'll need to chose the type of paste you want to perform.
There are so many things you can do with paste special; it's a topic in itself. At the very least, you probably already use paste special to strip out unwanted formatting and formulas (Paste special Values). But did you know that you can also paste formatting, paste column widths, multiply and add values in place, and even transpose tables? It's all there. Toggle autofilter If you frequently filter lists or tables, this shortcut should be at the top of your list. With the same shortcut, Control + Shift + L (Mac: Command + Shift + F) you can toggle filters on and off any list or data set.
But the best part is toggling off the autofilter will clear any filters that have been set. So, if you have a multiple filters active, you can 'reset' all filters by using the shortcut twice in a row: once to remove the filters (which clears all filters), and once again to add a new autofilter. This is far faster than fiddling with each filter manually.
![Excel shortcut fit column width Excel shortcut fit column width](/uploads/1/2/5/5/125515495/914873082.png)
Select all Many people know the shortcut for 'select all': Control + A. However, in Excel, this shortcut behaves differently in different contexts. If the cursor is in an empty cell, Control + A selects the entire worksheet. But if the cursor is in a group of contiguous cells, Control + A will select the entire group of cells instead. The behavior changes again when the cursor is in an Excel Table. The first time you use Control + A, the table data is selected.
The second time, both the table data + table header are selected. Finally, the third time you use Control + A, the entire worksheet is selected. Move to edge of data region This shortcut sounds boring but it is vital if you routinely work with big lists or tables. Rather than scroll up, down, right and left, manually just put your cursor into the data and use Control + Arrow key to move in any direction to the edge of the data range (On a Mac you can use Command or Control). The cursor will travel to the first empty cell (or the edge of the spreadsheet, whichever comes first). If you start in an empty cell, the behavior is reversed - the cursor will move to the first cell with content and stop. Move right = Control + Right arrow Move left = Control + Left arrow Move up = Control + Up arrow Move down = Control + Down arrow To see these shortcuts in action, see our video on.
How fast can the cursor move? How fast is the cursor moving when you use these shortcuts? Let's do a little math, shall we? Modern Excel has more than 1 million rows. If you put your cursor in A1 and press Control + down arrow, you'll be past the millionth row in less than a second. If we figure there are about 6 rows in an inch, then: 1,048,576 rows / 6 = 174,763 inches / 12 = 14,564 feet / 5280 = 2.76 miles 2.76 miles in 1 second. 60 = 165.6 miles per minute.
60 = 9,936 miles per hour. Since it really takes less than a second to travel more than 1 million rows, let's just call it 10,000 miles per hour. You're never going to beat it scrolling. Extend selection to the edge of data Navigating at high speed through a large table is great fun, but what really makes this idea powerful is selecting huge swaths of cells at the same time.
Because when you try to select large collections of cells manually (let's say 10,000 rows), you will be scrolling a long time. A really long time.
To save your sanity and avoid all that scrolling, just add the Shift key to the Control + Arrow shortcut, and you will.extend. the current selection to include all the cells along the way. The best part about using Shift + Control + Arrow is that your selections are perfectly accurate. Even though the cursor is moving at great speed, it will stop on a dime at the edge of a data region. Select right = Shift + Control + Right arrow Select left = Shift + Control + Left arrow Select up = Shift + Control + Up arrow Select down = Shift + Control + Down arrow Move to first cell in worksheet Navigating larger worksheets can get really tedious. Sure, you can use the scroll bars to scroll the worksheet into position, but using the scroll bars requires control and patience. If you just want to get back to the first screen in a worksheet, use the keyboard shortcut Control + Home (Mac: Fn + Control + left arrow).
This will bring you straight back to cell A1, no matter how far you've wandered. Move to last cell in worksheet In a similar way, you can jump to the 'last cell' in a worksheet using Control + End (Mac: Fn + Control + Right arrow). What is the last cell? Good question.
The last cell in a worksheet is at the intersection of the last row that contains data and the last column that contains data. Often, the last cell in a worksheet doesn't contain any data itself - it just defines the lower right edge of a rectangle that makes up the used portion of the worksheet. One good use of this shortcut is to quickly see if there is any other data in the worksheet that you're not aware of. You can use this to make sure you don't accidentally print 16 blank pages because there's stray data in cell BF1345, for some unknown reason. It's also useful when you notice that a workbook is suddenly a lot bigger on disk that it should be. In this case, it's likely that there's extra data somewhere in the worksheet.
Find next match Rather basic, but worth knowing: once you've set up a find, and have found at least one match, you can keep finding 'the next match' by using Shift F4 (Mac: Command + G). This is a nice way to step through matches in a worksheet methodically.
By the way: to activate Find, use Control + F (Mac: Command + F). On Windows and Mac, you can also use Control + H to activate Find and Replace. On Windows, this will open the find and replace dialog with with Replace selected. Select row / select column Both rows and columns can be selected with keyboard shortcuts. To select a row, use Shift + Space.
![Excel column width shortcut Excel column width shortcut](/uploads/1/2/5/5/125515495/386831926.png)
To select a column, use Control + Space. Once you have a row or column selected, you can hold down the shift key and extend your the selection by using the appropriate arrow keys. For example, if the cursor is in row 10 and you press Shift + Space, row 10 will be selected. You can then hold the shift key down and use the Up or Down arrow keys to select additional rows above or below row 10. Note that if you are working in an Excel table, these same shortcuts will select rows and columns within the table, not the entire worksheet.
Also note that once you have rows or columns selected, you can use other keyboard shortcuts to insert, delete, hide, and unhide. Add non-adjacent cells to selection You'll often need to select cells that aren't next to one another. You might want to enter the same data to several cells (see Control + Enter) change formatting, or even use the status bar to get an on-the-fly SUM for a group of random cells. This is easily done using Control + Click (Mac: Command + Click).
Just select the first cell (or cells) then hold down the control or command key and click other cells to add them to your selection. Show the active cell on worksheet Sometimes you have a worksheet open and the cursor is nowhere in sight.
You could press an arrow keys to bring the cursor into view (and move to a new cell at the same time) or you could consult the namebox to get the address. But you can also just use Control + Backspace (Mac: Command + Delete) to automatically scroll the cursor into view, nicely centered in the window. Display 'Go To' dialog box The Go To Special dialog is a bit like the Paste Special Dialog - within lies a treasure trove of utility hidden in an innocuous sounding control. Did you know you can use Go To Special to select only formulas? Only constants?
Only blank cells? You can do all that and a lot more. Unfortunately, the shortcut Control + G (both platforms) only gets you half way, to the Go To dialog box. From there, you need to click the Special button to get all the way to Go To Special. Control + G is still a worthy shortcut, however, because Go To Special is the gateway to many tricky and powerful features.
Chandoo has a good article that explains Go To Special in detail here: This video shows how to use Go To Special to select and delete blank rows: This video demonstrates using Go To Special to weed out rows that are missing values in a specific column: ENTERING DATA Start a new line in the same cell This is not so much a shortcut as something you simply must know to enter multiple lines in a single cell. This is often a puzzle to Excel users (for obvious reasons) and I have no doubt that this puzzle has resulted in hundreds of thousands, if not millions, of Google searches. Here is the answer revealed: Alt + Enter (Mac: Control + Option + Return) will add a new line inside a cell. Enter the same value in multiple cells This shortcut may not seem interesting, but you'll be surprised how often you use it once you understand how it works. Use Control + Enter when you want to enter the same value in multiple cells at once. This is a great way to save keystrokes when you want to enter the same value or formula in a group of cells.
You can even use Control + Enter to enter data into non-contiguous cells. (See the previous shortcut for selecting non-adjacent cells.) Control-enter also has another use: use it when you want to enter a value into a cell and stay in that same cell after hitting return. Insert current date / Insert current time No Excel shortcut guide would be complete without mentioning these stalwarts for entering the current date and time. To enter the current date, use Control +; To enter the current time, use Control + Shift +: If you want to enter both the current date and time, type control +;, then enter a space, followed by Control + Shift +: With either shortcut, excel will enter the current date or time using a valid Excel date in serial number format, with dates as integers and times as decimal values. You can then apply date or time formatting as you like. Fill down / Fill right These handy shortcuts allow you to quickly copy data from the cell above or the cell to the left, without using the typical 'copy, then paste' pattern.
To copy a value from the cell above, use Control + D. To copy data from the cell to the left, use Control + R. You can use these same shortcuts to copy data to multiple cells too. The trick is to select both the source cells and target cells before you use the shortcut. (This isn't necessary if you're copying to cells that are directly adjacent to the source cells.) For example, if you want to copy values from the row above into the next 6 rows in a table. Select the source row and the next 6 target rows. Then use control + D.
FORMATTING Format (almost) anything Now that the ribbon has taken over, this shortcut may seem unnecessary. After all, you can just click on all that bling-bling in the ribbon right?
But pay attention grasshopper, this shortcut is the gateway to a lot of formatting options that don't appear in the ribbon. Better yet, you can use this shortcut to instantly access a full set of formatting options, even when the ribbon is collapsed. When regular cells are selected, Control + 1 (Mac: Command + 1) opens the Format Cells dialog. From there, you have quick access to number formats, alignment settings, fonts, borders, fills, and cell protection, with no need to hunt these things down in the ribbon. When you're working with a chart, the same shortcut will open various formatting dialogs, depending on what you have selected. For example, if you have the chart area selected, Control + 1 (Mac: Command + 1) opens the Format Chart Area dialog. If you have data bars selected, the shortcut will open the Format Data Series dialog.
You can also use this shortcut when working with shapes and smart art. The bottom line: give this shortcut before you head out to hunt down a formatting option in the ribbon. Note: thanks to Excel guru for pointing out to me that Control + 1 is not just for formatting cells! Bold, italic, underline Basic, boring, yet essential: Bold = Control + B (Mac: Command + B) Italic = Control + I (Mac: Command + I) Underline = Control + U (Mac: Command + U) You should also know you can hold apply these formats to individual words and characters.
Just double click the cell to enter edit mode, select the text you want to format, and apply one of these shortcuts. Number formats These shortcuts are not critical, but it's worth knowing that you can apply seven number formats with keyboard shortcuts.
Each shortcut follows the same pattern: Control + Shift + symbol. If you spend a few minutes trying them out, you'll get the idea quickly: General = Control + Shift + Currency = Control + Shift + $ Percentage = Control + Shift +% Scientific = Control + Shift + ^ Date = Control + Shift + # Time = Control + Shift + @ Number = Control + Shift +! Conspicuously absent: the Accounting format. FORMULAS Edit the active cell You can either double click a cell or use F2 (Mac: control + U) to enter 'edit mode' for the active cell. Toggle absolute / relative reference If you work regularly with formulas and cell addresses, this is one shortcut is essential, and will save you a lot tedious editing cell references to add and remove the $ character.
To use the shortcut, first enter edit mode, then position the cursor in or next to a cell reference you want to change. Then press F4 (Mac: Command + T). Each time you apply the shortcut, Excel will 'rotate' one step through relative and absolute options. Starting with a relative reference, the rotation order works like this: absolute, row locked, column locked, relative.
So, for example for the reference A1, you'll see: $A$1, A$1, $A1, and, finally, A1 again. Note: on a laptop, you may need to use fn + F4 if function keys are used to control things like screen brightness, volume, etc. Video: Autosum selected cells Autosum works on both rows and columns. Simply select an empty cell to the right or below the cells you want to sum, and type Alt + = (Mac: Command + Shift + T). Excel will guess the range you are trying to sum and insert the SUM function in one step. For more control, first select the range you intend to sum, including the cell where you'd like the SUM function to be.
This prevents Excel from guessing wrong about the range in cases where there are blanks or text values in the sum range. For even more satisfaction, you can have Excel insert multiple SUM functions at the same time. To sum multiple columns, select a range of empty cells below the columns. To sum multiple rows, select a range of empty cells in a column to the right of the rows.
For the ultimate in shortcut satisfaction, you can have Excel add sum formulas for an entire table in one step. Select a full table of numbers, including empty cells below the table and to the right of the table.
Then use this shortcut. Excel will add a SUM function at the bottom of each column, at the right of each row, and, at the lower right corner of the range, giving you column totals, row totals, and a grand total all in one step. In the world of Excel shortcuts, it doesn't get much better than that. Toggle formulas on and off It can often be handy to quickly see all the formulas in a worksheet, without clicking into each cell. By using Control + ', you can display all formulas in a worksheet at once.
To dismiss the formulas and show the results of the formulas again, type Control + ' a second time. This gives you fast way to audit a worksheet.
You can see where formulas are used and to check for consistency at the same time. Insert function arguments This shortcut is a bit of a sleeper. You don't see it mentioned much, but it's pretty cool.
What it does: when you're entering a function, after Excel has recognized the function name, typing Control + Shift + A (both platforms) will cause Excel to enter placeholders for all arguments. For example, if you type '=DATE(' and then use Control + Shift + A, Excel give you '=DATE(year,month,day)'. You can then double-click each argument and change it to the address or value you need. Paste name into formula When you're editing a complex formula, that last thing you need is to have to leave edit mode to go find the name of a named range or constant. With this shortcut F3 (no Mac equivalent so far as I know, sorry!) you don't need to. Just press F3 and Excel will open the named range dialog box so that you can paste in the name you need. Accept function with autocomplete When you're entering a function, excel will try to guess the name of the function you want, and present an autocomplete list for you to select from.
The question is, how do you accept one of the options displayed and yet still stay in edit mode? The trick is to use the tab key.
When you press tab, Excel adds any parentheses as needed, then leaves the formula bar active so that you can fill in the arguments as needed. On a Mac, you need to use the down arrow key first to select the function you want, then Tab.
WORKING WITH THE GRID Insert rows / columns To insert a row or column with a keyboard shortcut, you need to first select an entire row or column, respectively. The shortcut is the same whether you are inserting rows or columns. With an entire row selected, use Control + Shift + + (Mac: Control + I) to insert a row. With an entire column selected, use Control + Shift + + (Mac: Control + I) to insert a new column to the right of the selected column. You can also insert multiple rows and columns.
Just select the number of rows or columns you want to insert before using the shortcut. As already mentioned, you can use a keyboard shortcut to select entire rows or columns: Shift + space to select a row, Control + space to select a column. Delete rows / columns Like inserting rows or columns, the key to deleting rows and columns to first select an entire row or column. Once you have a row or column selected, the shortcut for deleting rows is the same as for deleting columns: Control + - (both platforms). With this same shortcut, you can also delete multiple rows and columns. Just select the number of rows or columns you want to delete, then use Control +. Note: use the shortcuts we already mentioned to select rows and columns: Shift + space to select row(s), Control + space to select column(s).
Note 2: if you don't have an entire row or column selected when you use Control + -, Excel will present the Delete dialog box, which contains options for deleting rows and columns, and for shifting cells. The benefits of working with entire rows and columns Inserting rows and columns is a great way to organize data quickly and safely. By adding an entire row or column, there's no chance you'll accidentally push cells out of alignment somewhere else, because all cells are shifted the same amount. In a similar way, deleting columns and rows is a great way to clean up a worksheet quickly. In one fell swoop, you can slice out tons of junk that would be tedious to clean up manually. Before you start tidying up rows or columns that contain nothing useful, ask yourself: Can I just remove this stuff by deleting rows or columns? If so, then do it!
Excel doesn't care a bit how many rows or columns you delete. It will just silently re-add a fresh batch the instant you delete. Hide and unhide columns To hide one or more columns, use the shortcut Control + 0 (both platforms). Any columns that intersect the current selection will be hidden. If you prefer, you can also first select entire columns before using this shortcut. Note that column letters on either side of hidden columns will appear in blue.
To unhide columns, you must first select cells that span either side of the hidden column, or select columns that span the hidden column(s). Then use the keyboard shortcut Control + Shift + 0.
Note that you are just adding Shift to the shortcut for hiding a column. Hide and unhide rows To hide one or more rows, use the shortcut Control + 9 (both platforms). Any rows that intersect the current selection will be hidden. You can also first select one more more entire rows if you prefer. Note that row numbers on either side of hidden rows will appear in blue. To unhide rows, you must first select rows that span either side of the hidden row, or select entire rows that span the hidden row(s).
Then use the keyboard shortcut Control + Shift + 9. Note that you are just adding Shift to the shortcut for hiding a row. CHARTS Create an embedded chart To create a embedded chart, first select the data that makes up the chart, including any labels. Then use use the keyboard shortcut Alt + F1 (Mac: Fn + Alt + F1.).
Excel will create a new chart on the same worksheet, using your current chart default settings. I'm not able to get the Mac shortcut to work on my Mac (Lion, Excel 2011) at the moment. Create chart in new worksheet To create a chart on a new sheet, first select the data that makes up the chart. Then use use the keyboard shortcut F11 (Mac: Fn + F11). Excel will create a chart in a new sheet based on your current chart default settings. This is a great way to sanity-check data in your worksheet.
Compatibility: Windows 10, 8.1, 8, 7, Vista, XP Download Size: 6MB Requirements: 300 MHz Processor, 256 MB Ram, 22 MB HDD Limitations: This download is a free evaluation version. Full repairs starting at $19.95. Column width excel for mac different size is commonly caused by incorrectly configured system settings or irregular entries in the Windows registry. This error can be fixed with special software that repairs the registry and tunes up system settings to restore stability If you have column width excel for mac different size then we strongly recommend that you.
This article contains information that shows you how to fix column width excel for mac different size both (manually) and (automatically), In addition, this article will help you troubleshoot some common error messages related to column width excel for mac different size that you may receive. Note: This article was updated on 2018-12-22 and previously published under WIKIQ210794.
Contents. Meaning of column width excel for mac different size? Column width excel for mac different size is the error name that contains the details of the error, including why it occurred, which system component or application malfunctioned to cause this error along with some other information. The numerical code in the error name contains data that can be deciphered by the manufacturer of the component or application that malfunctioned. The error using this code may occur in many different locations within the system, so even though it carries some details in its name, it is still difficult for a user to pinpoint and fix the error cause without specific technical knowledge or appropriate software. Causes of column width excel for mac different size?
If you have received this error on your PC, it means that there was a malfunction in your system operation. Common reasons include incorrect or failed installation or uninstallation of software that may have left invalid entries in your Windows registry, consequences of a virus or malware attack, improper system shutdown due to a power failure or another factor, someone with little technical knowledge accidentally deleting a necessary system file or registry entry, as well as a number of other causes. The immediate cause of the 'column width excel for mac different size' error is a failure to correctly run one of its normal operations by a system or application component. More info on column width excel for mac different size RECOMMENDED: Im trying to change from pc to mac, i want to know how to change column width change in mac.
Figure that out? The Excel column width and row height units?
Who can Anyone else? It measures 1.4' 1.4' is 210 pixels. What is the equivalent in inches of Interesting question. If I set it to 100, Hello.
Is there a problem when importing data from access. How are you Most of the maximum characters is 255. Can you give us a sample of a information is missing. Doing the import? Lika2know record from Access that you want to import?
Ok excel columm width work aound to this? This is causing me a massive P.S.
Is it possible to have 2 (at least) column heading bars in excel 2000? Any advice perhaps I can give you a workaround? No, it cannot done in Word. But it can be be done in Excel. Drew If you can tell me why, is extremely appreciated.
Or Select the column or columns can also do the same for autofit for rows. Hope that the Cells group, click Format. In 2003, you could go to the column format and click on 'Auto' for as many columns as you liked but in 2007 I can't seem to find it anywhere? It seems click AutoFit Column Width. On the Home tab, in Under Cell Size, that you want to change.
The same applies when you select single columns You to be missing? Helps This is totally simple/basic, but I and read for hours in Help for Excel. Nothing pertinent to my worksheet with 2 different pages.
When trying to compare or adjust column widths, different units of meansurement are in Please help. Question and no solution evident. Have searched both my Excel reference books don't know how to handle this. Excel 2010 - created a place; Cannot discover how to make both the same so I can compare apples to apples. From half screen width to full screen, or just drag the left or right border) the column widths in Thunderbird dynamically change. Something I've only come across in Thunderbird, never in any other software - when you change the window width (e.g.
Also, if one changes the BTW I'm using Thunderbird 17.0.8 on Win7 I also use Thunderbird (currently 17.0.8) I having in-depth knowledge of Thunderbird and associated issues. Other software does the sensible thing and simply moves columns out of view / into width of a column (i.e. There are a lot of very knowledgeable folks - either by some (deeply buried) setting or by an add-on? By dragging the column heading edge), again the columns (to the right) dynamically change size. Can't answer your question but it might be worth posting on this forum. Is there some way of getting Thunderbird to do the same view columns as the screen width changes (or as other column widths are intentionally changed). I have set the Gap Width to 0, so gratefully received!
Thanks, Rob Double click the column, go to scale. Using Excel 2003, is there any way to edit I'm not sure how else to make the columns wider. Any suggestions the width of the stacked columns within a chart? Widths with in the same column? Can you have different size cells do you do that?
If so how I am tired of dragging the Details or Name in OPTION THREE in the tutorial below may work for this. It always opens a window in in advance. Regards Rick Hello Musicis, One of the methods (Name, type, total size, etc) can be permantly adjusted.
Wondering if the width of a particular column to see all. Can anything be done to adjust all this? Column - Customize column to more width so to see all information. Thanks Hope this helps, Shawn Never wide enough default at about 1 1/2 inches wide. I am trying to make the column widths the folder and return to it, it always reverts to the 455 pixel width.
How can I maintain set to 455 pixels. Currently they are narrower in the List View of My Files. I can change that while I am in the folder, however, after I close the narrower width? Im using Excell the width is of a column in excell? How would one know how many pixels 97.
Name, just the first 8-10 charachters. I don't need the whole file Hello Mark, Normally, Windows will remember the view set in only a single folder, and for how it was when last closed. I see no 'setting' for this to keep it from defaulting back to the smaller size.???? In outlook, I have the normal navigation pane, the happening or if it can be fixed? Do you know why this is bottom reading pane, and the normal to do bar.
Preamble: I?m running windows 7, with office 2010 (outlook). Thanks in advance I have a 24? Monitor, so able! To view a fair bit on my screen. I started a new, blank are 'locked,' and I don't see that. When I try to move the column width by putting the cursor between the column column to the width I want. PLEASE please tell letters and dragging to size I want, ALL the columns change to the same size!
I want to adjust each me what to do! I have looked at whether cells workbook and then pasted in data. So try open/save as, adjust the size, go to the next folder up, help me solve this frustrating issue! Just about every time I do a 'File Open' or 'Save As' command, the columns in the ensuing window that opens are too narrow. I usually have to drag the 'Name' column to make to a preset width, regardless of what application I'd working in? Thanks on advance to whoever can had a problem similar and that fixed it. Sometimes the view settings revert it wider so I can see the entire file name.
Am I just missing something simple or do adjust the size, etc, and then close the last window with the x. I can't reproduce your problem exactly, but I to whatever the parent folders use. Is there a way to fix the column width globally, I need to edit something in the Registry? I wish to narrow the width of the 'Size' column in a Vista Windows Explorer window beyond that which is permitted by the operating system. In XP you could drag it to any required width, but Vista reopened as requested.
Ideas welcome! Thread blocks you from reducing it beyond the default minimum, using unecessary screen resources. I would like to have a more descriptive title on some pinned entries. Thank you XP SP2 Home: Is there any way to change the column width on the left side of the Start menu. Got a free full version of 9 off a cd, which I have just preview.You can see the preview is nothing like how it should be.click hereg-g Top part is part of the table from page design, lower part is from page I have made up an 'image' of what happens. I've been using version 7 without problems for years. Any ideas please?g-g No replies yet, but installed.Exported a site as a template from version 7 & imported it to version 9.