LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to search for nearest nonblank cell in previous rows? joeu2004 Excel Discussion (Misc queries) 8 January 12th 08 06:14 PM
Isolated rows within a single cell? Ryan P. Excel Discussion (Misc queries) 3 November 13th 06 04:06 PM
filling combo boxes from single outer source alekm Excel Discussion (Misc queries) 1 February 17th 06 01:49 PM
filling information from one cell and filling another. Dianne Excel Worksheet Functions 1 August 15th 05 08:14 PM
Filling excel entire row/column instead of single cell from an array shitij Excel Worksheet Functions 3 July 13th 05 07:44 AM


All times are GMT +1. The time now is 07:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"