Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Senior Member
 
Posts: 118
Default how to copy an excel sheet to this message

i want to copy an excel sheet to this message. when i copy paste, it missses the table property. i want to copy the exact file with all its property in excel to this message. is it possible? i copied the excel sheet to ms word first. then i copied that to this message, even then the table property is missing.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,872
Default how to insert serial numbers to rows?

Hi Sumesh,

Am Fri, 13 Apr 2012 14:52:39 +0000 schrieb sumesh56:

-----------------------------
A B C
-----------------------------
SL.NO TITLE
-----------------------------
1 abc 1
2 wett 1
3 0
4 jkhghj 1
5 0
6 0
7 rloljo 1
8 0
9 0
10 fddde 1
11 0
12 rderu 1


try in B2:
=--SUBTOTAL(3,$B$2:B2)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,872
Default how to insert serial numbers to rows?

Hi Sumesh,

Am Fri, 13 Apr 2012 21:48:03 +0200 schrieb Claus Busch:

try in B2:
=--SUBTOTAL(3,$B$2:B2)


sorry, above is a typo
try in A2:
=--SUBTOTAL(3,$B$2:B2)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,514
Default how to insert serial numbers to rows?

Here's one method I use to auto-number entries in a table. Removing
rows will cause the remaining rows to automatically renumber, adjusting
for rows that are added/removed...

Select cell A2
Open the Define Names dialog;

In the Name box type: '<sheetname'!LastCell
..where you substitute the actual sheetname for <sheetname;

In the RefersTo box enter =A1
Click the OK button to close the dialog

In cell A2 enter 1
In all the cells below enter =LastCell+1

If you want the cells to display a format then use Custom on the Number
Format tab of the Format Cells dialog.


Another way:
If you don't want to use a defined name then you can use the Row()
function as follows...

Scenario is Row1 has headers, data starts in Row2

In A2 type =Row()-1

Optionally, you just need to minus the row number immediately above the
first row of data if the start row isn't Row2. So.., if data starts in
Row6 then the formula to auto-number the data is...

=Row()-5

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


  #5   Report Post  
Senior Member
 
Posts: 118
Default

Quote:
Originally Posted by GS[_2_] View Post
Here's one method I use to auto-number entries in a table. Removing
rows will cause the remaining rows to automatically renumber, adjusting
for rows that are added/removed...

Select cell A2
Open the Define Names dialog;

In the Name box type: '<sheetname'!LastCell
..where you substitute the actual sheetname for <sheetname;

In the RefersTo box enter =A1
Click the OK button to close the dialog

In cell A2 enter 1
In all the cells below enter =LastCell+1

If you want the cells to display a format then use Custom on the Number
Format tab of the Format Cells dialog.


Another way:
If you don't want to use a defined name then you can use the Row()
function as follows...

Scenario is Row1 has headers, data starts in Row2

In A2 type =Row()-1

Optionally, you just need to minus the row number immediately above the
first row of data if the start row isn't Row2. So.., if data starts in
Row6 then the formula to auto-number the data is...

=Row()-5

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
dear Garry,
it is perfect. it works.this is what i was searching for.thanks a lot and have a nice day.

i would like to give a description of my experience to those who want it.
1.suppose you have data in col A.there are blank rows in between data rows. you want to delete the blank rows and to get the data rows serial numbered.
2.give a name to the sheet(eg=test)
3.insert a col on the left. now the data in col B.
4.you have a header in B1.data from B2
5.select col A2.enter =Row()-1
in col A3 enter =A2+1
home-find-goto A50 pressing the shift p enter. then press control D. now you have serial numbers in col A from 1 to 50.

6.now home-find-goto-enter-A50:B50
pressing the shift p enter.find-goto special-blanks-p enter
7.then you press the delete btn on the tool bar. now the blank rows have been deleted and you get the data rows fully numbered.

-----------------------


  #6   Report Post  
Senior Member
 
Posts: 118
Default

Quote:
Originally Posted by sumesh56 View Post
i want to copy an excel sheet to this message. when i copy paste, it missses the table property. i want to copy the exact file with all its property in excel to this message. is it possible? i copied the excel sheet to ms word first. then i copied that to this message, even then the table property is missing.
i get reply for the questions i asked somewhere else(in another post).i am still waiting a reply for this problem. thanks.the admin may guide me whether i should repost this to get a reply.
Reply
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
Copy sheet to different workbook sizing error message Jvwulffen Excel Discussion (Misc queries) 2 November 20th 09 10:36 PM
Excel Warning Message on New Sheet Created polar[_4_] Excel Programming 8 July 31st 09 12:10 PM
Error message in my Excel sheet ub Excel Worksheet Functions 2 May 29th 07 08:45 PM
copy sheet error message brucearthurhall New Users to Excel 1 March 21st 06 02:18 PM
Copy and Paste from Excel into Outlook Email message TroyB[_2_] Excel Programming 0 November 10th 04 09:01 AM


All times are GMT +1. The time now is 12:15 PM.

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

About Us

"It's about Microsoft Excel"