Copy this formula from B6 down to B7 through B14 (not B15, because this formula totals this column).Īdd formulas to total spreadsheets dimensionally from Jan through Dec. On the YTD spreadsheet, position your cursor on B6 and enter this formula: = sum(Jan:Dec!B6). For this example, the dimensional totals only calculate Jan through May. Rename spreadsheets and spreadsheet tabs.Īccess spreadsheets Feb through Dec and enter some random numbers in the Monthly Totals column-cells B6 through B14 (not B15, because it’s a formula). Note: Keep spreadsheet tab titles as short as possible for easier dimensional calculating. Next, change the titles of each sheet to match the tabs (type over ‘January 2014’ with correct titles). Double-click the remaining sheet tabs Sheet1 (2) through Sheet1 (12) and rename the worksheet tabs Jan, Feb, Mar, etc., through Dec. Check the box that says Create a Copy, select (move to end), then click OK.ĭouble-click the tab that says Sheet1 and rename it YTD. Right-click the mouse and select Move or Copy from the drop list. Place your cursor on the Sheet1 tab at the bottom of your Excel window.
Increase indent excel 2013 full#
With your cursor on B15, click Copy, select cells C15 through G15, and press Enter.Ĭopy this spreadsheet 12 times for a full year’s worth of data. Next, position your cursor on cell B15 and enter this formula: =sum(B6:B14) and press Enter. Select cells B6 through G15, then click Center, and then click Increase Decimal (two times) to format for two decimal places (both on the Home menu tab). Adjust column widths to fit the data entered. In cells A6 through A15, enter this information: Electricity, Gas, Water, Garbage, Shop Phone, Internet, Alarm Service, Maintenance, Cleaning Services, TOTALS. Note: You can center both horizontally and vertically. Select cells A4 through G5 and click Center from the Ribbon bar on the Home menu tab. In cells A5 through G5 enter this data: Utilities, Totals, 28%, 32%, 17%, 23%, and Verified.
In cells A4 through G4 enter this data: Total, Monthly, Carrie C, Marilyn H, Pat B, Donna A, and Percent Total. Be sure to use the actual percent sign when you enter these numbers. The rent is divided equally, but the utilities and other fees are calculated by percentages of use, therefore each designer pays a different price. This small business has four designers who rent space. Choose Custom and in the Type field box above the list enter mmmm yyyy, then click OK. Choose Date from the format options, and you’ll notice that there is not a format listed for the month spelled out with a four-digit year. Right-click the mouse in that cell and choose Format Cells from the dropdown list. In Excel 2013 Home Menu, select Blank workbook.