![]() With cells A4 to AN4 selected, press Ctrl+C. This is usually the fastest way to correct a mistake when you make one. IMPORTANT NOTE: Pressing Ctrl+Z will undo most of the actions you can take in Excel. If you do not, you can go back to the Border tab and clear the Text box by clicking on the None box at the top of the dialog. You should now see a line bordering the bottom of cells A4 to AN4. This means it will be used as the bottom border of each cell in the selection. The line style you picked should now appear along the bottom of the Text box. Click on the one on the left that shows a solid line at its bottom. Around the large box that says "Text" you will see some smaller boxes. Since we are basically doing underpainting here, I would recommend one of the light and unobtrusive broken line styles. To use this tool you must first pick a line style from the box at the right. Right-click on the selection and choose Format Cells., then click on the tab labelled Border.Ĭ. You should see a row of 40 cells highlighted. Expand the window or scroll it if necessary until you can see cell AN4. Expansions are 4x4 in size, so there will be 10 by 10 expansion slots.Ī. The dimensions of the cityspace are 40 by 40 city cells, which means its worksheet representation will cover rows 1 to 40 and columns A to AN. I think this is a good idea, but it is not essential. Step 5: Delimit the city expansion slots. ![]() IMPORTANT NOTE: If you do not see one of the menu entries mentioned as being on a pulldown menu, click on the button with a double down-arrow at the bottom of the menu. Since you will probably begin using another worksheet by first copying the master worksheet to it, part b is not very important. In the box that pops up enter the value 3 and press OK. ![]() In the box that pops up enter the value 17.5 and press OK.Į. On the menubar select Format, then Row, then Height.ĭ. Right click on the tab for the master worksheet at the bottom of the window and click on Select All Sheets.Ĭ. With the master worksheet active select the entire worksheet ( Ctrl+A).ī. You are free to experiment with different values for these settings, of course, but the ones I give here work pretty well for me.Ī. We do this by setting their row height and column width. You can update the master worksheet by reversing the copy/paste procedure once the changes to your city are in place. You want to use the source formatting, so ignore the little menu that pops up when you do the paste. Click on cell A1 and press Ctrl+V (paste). Activate the worksheet you wish to copy to by clicking on its tab at the bottom of the window.ĭ. Select the entire master worksheet by pressing Ctrl+A or by clicking on the small, empty box just above row 1 and to the left of column A.Ĭ. How to Copy the Master Worksheet to a Different Worksheet:Ī. The other worksheets are for experimenting with changes. It should always exactly represent the current state of your city. It will now appear on the tab at the bottom of the window. On the menubar click on Format, then Sheet, then Rename. The file name will now appear at the top of the window. Choose an easily accessible folder such as MyDocuments and a name for this file. When the New Workbook menu pops up, select Blank workbook and your workbook (file) will appear. On the menubar (the one with text on it) click on File and then New. (I have been told that these instructions will also basically work with certain freeware spreadsheet programs, but I cannot personally confirm that.) By using them even someone who has never worked with Excel or any other spreadsheet program in his life should be able to turn out a fine model of his city in no time. that they were written to be simple and specific to the point of rudeness. The following instructions explain in detail how to do that. I am sure that without this remodeling tool I would have on occasion missed the ideal solution to a remodeling or repacking problem.Įxcel in its entirety is a daunting application, but using it to make a model of your city is much simpler than you might think. Using the Excel spreadsheet program I have created city models that allow me to find the best way or ways to rearrange existing buildings and create space for new ones. It is important to players like myself who do not purchase many city expansions that they get the most use out of every single cell in their cities.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |