could someone point me in the right direction please. I am working on a spreedsheet that i can use for a po log. on the first sheet i want to have a list of...

I have never used excel b4 and need 2 sum the columns in a workbook. Can someone please tell me in laymens terms how to do it . If I click on the funny E icon...

The first part of this is relatively easy. Right click on a worksheet tab then select View Code. Double-click the This Workbook object then change the two...

How can I format an entire column to add a fixed percentage to the number in each row and display the anwer in the same row, next column? Please help, Bob

Mike, Caution: the techinque I'm going to share can have unintended consequences. Let me explain. If you hold the Ctrl key down and select the tabs of the...

Hello, Like so many others, I am an Excel newbie. I was a mainframe COBOL programmer in another life, but that was a few years back :rolleyes: My manager...

I am trying to create a spreadsheet in Excell and want to lock the formula cells to they cannot be typed over accidently destroying the function??

Hi I get an error (#DIV/0!) when I divide one cell by the other and there are no entries in the cells. How can i get the folrmula to surpress the error (show...

I have a workbook with 12 worksheets or tabs say Tab1, Tab2...Tab12 in it, each dedicated to one of 12 employees respectively to say Emp1, Emp2,..Emp12. The...

I am newbie here and is having hard time in doing this. I have an excel workbook which has two sheets Grp1 and Grp2 within these sheets i have unit and id...

One of our clients has a Peer-To-Peer environment with one of the peer computer hosting all of the shared folders. When the other peers try to browse to the...

Hi, For instance, A1 = 8:20, B1 = 16:30. I need to compute in C1 the following: B1 - A1 - 0.5 hour. What is the formula? If I use formula B1 - A1 - 0:30 I...

Hello and thank you in advance for the help! I was using Excel tonight and with regard to two things thought that "there must be a better and easier way to do...

Good Morning In a sheet I have a checkbox and a combo-box. I want to protect every cell in that sheet, make it "Read-Only", the only things I don't want to be...

One of our users is still having trouble with an Excel spreadsheet. It is printing in blue ink on his pc and black on everyone elses. I modified...

Hi , i have a problem that when ever i copy from a website for score result ,example 2-1 , excel will convert it to date format . Is there a way for me to stop...

I need help in creating a form in Excel that can retreive data that is due every three months

is there a way to set up a spreadsheet so that I can add info to it when someone else has it open? Thanks for any help you can provide! Alan

Hi there; I have a file with below structu A1: name A2:E93 contain data then A94: name A95:E186 contain data then again continues till: A5860: name

I received an email with a large group of spreadsheets. Each sheet has a different title. I want to save 1 paticular sheet and save it as a template. Any help...