This content has been archived, and is no longer maintained by Indiana University. Information here may no longer be accurate, and links may no longer be available or reliable.
Mac VBA Code for word/ Multiple pictures into columns The Code below does exactly what i need it to do on my PC. Just can't get my head around why it won't work on my mac. I will admit that I am not a Mac person. Here is the code any help wold be greatly appreciated. Search HelpSpa.com. Home; MS Office. Word; Excel; Powerpoint; OneNote; Outlook; Access; Apple. OS X; iPad; iPhone.
In Microsoft Word, you can set up either traditional columns ornewspaper-style columns. Traditional columns are simpler to set up,but can be difficult to work with, as you have to fill the firstcolumn before you can proceed to the next. With newspaper columns,however, you can more easily switch between columns; also, informationyou enter will not overflow into another column.
On this page:
Traditional columns
To create traditional columns in a document:
Word 2007
- Highlight the text you want to format; if you do not highlight anytext, Word will format the entire document.
- Click the Page Layout tab, and then selectColumns....
- Choose the format of your columns. You can select a preset,automatically formatted number of columns with equal spacing byclicking One, Two, Three, orFour. You can also manually select the number, width, andspacing of the columns by clicking More columns....
- Click OK.
Word 2003
- From the Format drop-down menu, selectColumns....
- Choose the format of your columns. You can choose from presetcolumns, or you can manually select the number, width, and spacing ofthe columns.
- Click OK.
Newspaper-style columns
To create newspaper-style columns using a table:
- Open a new document.
- In Word 2007, from the Insert tab, click Table,and then select Insert Table.... In other versions ofWord, from the Table menu, choose Insert, and thenchoose Table....
- In the 'Number of columns:' field, type the number of columns youwant in your document. For 'Number of rows:', type
1
(the number one). - Click OK to create your table. At this point your tablewill probably be small.
You can also add or remove table borders:
- Move your cursor to the table. In Word 2007, from the PageLayout tab, select Page Borders. In previous versionsof Word, from the Format menu, select Borders andShading....
- Choose the border options you want for your table. You can choosefrom presets (such as 'None') on the left side of the window, or youcan manually select which borders to turn on or off from the 'Preview'section on the right.
- Beneath the 'Preview' section, you will see 'Apply to:'. Makesure this option is set to Table if you want your borderselection to apply to the entire table.
- If you see gray lines where you have chosen not to have a border,don't worry. These are non-printing gridlines meant to help you seewhere your columns are. To turn gridlines on and off:
- Word 2007: From the Layout tab, selectView Gridlines.
- Previous versions of Word for Windows: From theTable menu, choose Hide Gridlines or ShowGridlines.
- Word for Macintosh: From the Table menu,check or uncheck Gridlines.
As a startup entrepreneur you get lists of name in Excel spreadsheets and in most cases there is one column with the first name and a column for the last name, but on occasion both names are in the same column. Or you get the City, State, and Zip in the same column and can cause headaches with having to sort this data.
Along comes MS Excel 2008 which has a data trick that helps clear up your list of names or any list for that matter. Let’s take a look at how we can do this.
Here’s an example of what I mean.
MS Excel. As you can see from the image above, this is a typical example of what you might get, or the first name and last name positions are changed. Either way, you have the full name in a column that you’d like to split out into two for both sorting reasons and for mail merging your data in form letters.
Start by opening up your file into an Excel sheet with the names in the column. Here’s the steps.
1. Highlight or select the data in the cells you want to split.
2. Select the menu Data > Text to Columns and begin going through the necessary steps to split the data into two columns.
3. How is the data delimited? When you select the Text to Column menu you’ll have two choices to select from: a delimited file that has either tabs or commas separating both names, or a fixed column width, i.e. 25 characters for example, if you get your data from a large database. In most cases you’ll get a delimited file where either the comma or tab will be the deciding factor of your file. There are other defining “Text qualifiers” that can help separate your data. In the second image you can see that Excel has given you a view of what your data will look like when you have defined how the text is handled by Excel. If you need to change your mind, just hit the back button and redo your selections until you get it correct. This is what it should look like once you have done the appropriate steps.
4. Follow through until you arrive as how you want your data to be split and then hit the “Finish” button.
![Two columns on word for mac download Two columns on word for mac download](https://oae.stanford.edu/sites/default/files/msword_mac2011_col2.png)
You’re done.
As always, it depends on how large your data set is, whether the list of names is around 20 you could do it manually and would be quicker, but the larger your data the more you’ll need the tools to speed up the process.
Runner Up: Search and Replace: If you are not planning on importing the data into a database or contact management program and have a text document, you can always open up and do a “search/find and replace” and replace the comma and space, spaces, or tab characters with something that you need instead.
The Mac application TextWrangler by Bare Bones, a free app from them, which does a LOT more to just plain text for you.