General

Key Board shortcut to Status bar
Hi, can anybody help in getting know the key board short cut for Status Bar in Excel from where we know the count,max min, avg or sum of the amounts. regards, radhakant ... 19 Apr 2010 14:41

Pivot Table Groupings Fail if 1of the items isn't in the nextdata
Hi Jerry Double click on the field Code, and select Show Items with no data. -- Regards Roger Govier Jerry G wrote: I am Grouping items together in a Pivot Table and everything works fine until I use the next months data. For example, I have different types of earning codes and I am grouping as f... 19 Apr 2010 05:21

How to undo overwrites?
i was typing my data whereby i accidentally overwrite the new file on the existing file name...is there any way to undo that? ... 19 Apr 2010 08:27

How to use Windows command within Excel macros
Hi, I want to select a bunch of text data separated by commas from a website, use Windows copy command to copy and paste it into a worksheet in Notepad and save it as a text file. How can I do that? That's all. In case you want to know further, I then can open the text file within Excel as a comma delimit... 19 Apr 2010 19:52

Top row of excel stays even in sorting
I need a header in the top row of my excel worksheet so that even when I sort the data the top row remains the same. ... 19 Apr 2010 05:21

Rating
please Sir: if i take salary as 1000 $ per month , and this amout increasing annually by 10% it comes 1100$ then 10 % for next year and so on.... how can i find out the change rate periodcally for 10 years means .. what will be my salary at month in the year 10?? -- Eng.kareem Elsafty ... 19 Apr 2010 04:19

Excel, custom format
I have data entered like this : AA-BB-999-xxxxx-zz-Abcdefghij Klmno, PRSTUVW AA-BB-888-zzzzz-zz-Abcdef Ghijk, LMNOPRSTUV When i enter the data in A1, A2 cell, and in B1, B2 i want to have only: AA-BB-999 AA-BB-888 After that in C1, C2 i want to have: KK-AA-BB-999 KK-AA-BB-888 How to do it? Especi... 19 Apr 2010 07:25

How to arrange data
Hi i am about eating an inventory database for a small makeup store, however thier product are many in terms of category and group. you have the lip glosses , lip liners, eye liners and so many others like skin care stuff. what will be the best way to arrange this data should i put all the product in one colum ... 19 Apr 2010 05:21

Add and edit a shape in VBA
Hi, I have written code to add a rectangle and a line in VBA. When I run the code it sometimes works fine. If I use F8 to step through the code the code to add the line works fine but not if I run the code as usual. The problem with the rectangle is that the text is not inserted into the rectangle. What is wro... 19 Apr 2010 11:34

How do I use standard notepad (unicode) font for special chara
nope, even when opened in Word or even back in Excel, they open with ???? instead of the proper characters. "Sheeloo" wrote: Excel must be exporting the special characters correctly. The text editor you use does not support special characters. Try to import the text file in MS Word and see whether you... 19 Apr 2010 00:08