How do I make a t-account in Excel?

Question

Help anyone!

Can't go there; filter. Any other ideas?

Answer 1

very simple. make sure you have the "formatting" toolbar shown on the top of the screen (if youre unsure, click on view-toolbars-formatting)
one of the icons is for "borders". click on the drop-down arrow on the right side of the icon and it will show you all ways you can put borders around a cell.
highlight the cells with your mouse and you can put an underline under them by clicking on the borders' icon. (to form the top of the T-account.) you can highlight a column of cells and click on 'borders' icon to also put a border on the left or right side of the cells.

if you are referring to actually adding up the columns, use the auto sum feature on the standard toolbar. (it looks like a capital E)

i hope you can understand what i wrote!

Answer 2

Are you talking about a T-account in accounting homework? T-accounts whether made on excel or a plain sheet of paper start with a T or two columns with debits or pluses in the left hand column and credits or minuses in the right hand column. When you are working an accounting problem and you know a transaction would affect an account in a certain way you would post that amount in the appropriate column. Like this, make two t-accounts one for cash and one for inventory. When you spend cash to buy inventory you would put the amount on the right hand side of the cash account and you would put an equal amount on the left hand side of the account for inventory. As long as you make an entry on the right side for each entry on the left side you will stay in balance. When you are finished posting all the transactions in the problem you tally all the colums and get the difference. A positive difference results in a debit and a negative results in a credit balance. You will need one t-account for each ledger account used in your transactions.

Answer 3

How To Do T Accounts

Answer 4

click on the downward arrow right to the border tool, from the drop dpwn menu, take draw borders. take the style of line u like and draw from lets say column B to E. if u like a date column draw upto G from B. Draw a verticle line in the middle of the horizontal line u just drew. use the colum B and D for ur entries and C and E for the amounts...change the columns if u want a date clomn..
hope this helps u..

Answer 5

A "t account" is just a list of debits and credits. The titles make the top of the "T" and the numbers run along the sides of the "T". You can take your information and use row one for titles and starting in A2 and B2 list your debts and credits.

Answer 6

Easy...


two columns, Debit, credit

at end of each do:
=sum(A1:A10) if the account has 10 rows

Add a column for text explanation or more if you wish.
Use a row at top for header if you wish

RTFM (Read the freakin manual) for EXCEL

Answer 7

how to create a graph in exal perticular cell

Answer 8

t-account - please elucidate.