View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Edward Letendre Edward Letendre is offline
external usenet poster
 
Posts: 10
Default filling a single cell before the sum of the previous rows.

In other spreadsheet programs, you would create a spreadsheet with the
following information, row by row

21
10
15
15
1

then you would request a sum of the rows and wth some formatting it would
look like this:

21
10
15
15
1
--
62

where the - is, you would use \- and press enter to fill the single cell.

Can this be done in any and or all versions of excel and how is this done.