Hi, is there any way to make the spread sheet wider so i can use it up to column ZZ .

Any help will be highly appreciated...

thanks....

Ad

In the bottom right hand corner, there is a little slider that will probably say 100% right now. move it down to like 75% and the zoom will be smaller

Posted on Oct 24, 2012

Ad

In Excel 03, I went to Help, typed in "column" and they had a "add or delete columns" topic. Did seem to answer your question. Very modestly submitted. I ain't no expert, just nosy.

Posted on Jan 26, 2008

Ad

Hi,

A 6ya expert can help you resolve that issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).

click here to download the app (for users in the US for now) and get all the help you need.

Good luck!

Posted on Jan 02, 2017

Use a standard spread sheet and set up the columns as you require. Date, Material description, supplier, cost etc for instance.

Aug 19, 2017 | Computers & Internet

Click on the column-heading to select the entire column.

Right-mouse-click to select "copy".

Move the mouse-pointer to where you want the copy to appear.

Right-mouse-click and choose "insert copied cells".

Right-mouse-click to select "copy".

Move the mouse-pointer to where you want the copy to appear.

Right-mouse-click and choose "insert copied cells".

Sep 16, 2014 | Microsoft 1994 Office Excel Spreadsheet...

any greyed out area is a non accessible are

either the spread sheet your are using is not advanced enough or that area is read only requiring an administrator's authority to access it

suspect that it is read only and is not for editing

if you go google and type in -- user manual for excel spread sheet-- there is a pdf version ( around 900 pages ) which has everything you need to know for excel spreadsheets

a good publication if you spend lots of time in excel as it misses nothing

either the spread sheet your are using is not advanced enough or that area is read only requiring an administrator's authority to access it

suspect that it is read only and is not for editing

if you go google and type in -- user manual for excel spread sheet-- there is a pdf version ( around 900 pages ) which has everything you need to know for excel spreadsheets

a good publication if you spend lots of time in excel as it misses nothing

May 11, 2017 | Savy Soda iSpreadsheet Free

The easiest way to do this is to use Excel spreadsheet.

This is what you need to do.

Create a label at the top of each column as detailed.

Add a employee to each row under Name of employee

Then against each employee add the data and the formula in the relevant cell under each column.

The first column - Name of the employee

2nd column - salary rate per hour

3rd column - hours worked

4th column - gross pay (formula = salary rate X hours worked)

5th column - tax deduction

6th column - other deductions

7th column - total deductions (formula = tax deduction + other deduction)

8th column - net pay (formula = gross pay - tax - total deductions)

At the last row you can include a total for Gross salary paid, total Tax collected etc.

Once you have setup this spread sheet make a copy of it and save it as a template.

You can then copy this template for each new financial year so you do not have to create a new one each year, you only need to make minor changes for new employees, rates of pay etc.

Another way to make a salary program is to use Access Database. You need more skills to do this, but it can provide greater reporting capabilities.

This is what you need to do.

Create a label at the top of each column as detailed.

Add a employee to each row under Name of employee

Then against each employee add the data and the formula in the relevant cell under each column.

The first column - Name of the employee

2nd column - salary rate per hour

3rd column - hours worked

4th column - gross pay (formula = salary rate X hours worked)

5th column - tax deduction

6th column - other deductions

7th column - total deductions (formula = tax deduction + other deduction)

8th column - net pay (formula = gross pay - tax - total deductions)

At the last row you can include a total for Gross salary paid, total Tax collected etc.

Once you have setup this spread sheet make a copy of it and save it as a template.

You can then copy this template for each new financial year so you do not have to create a new one each year, you only need to make minor changes for new employees, rates of pay etc.

Another way to make a salary program is to use Access Database. You need more skills to do this, but it can provide greater reporting capabilities.

Mar 24, 2011 | Computers & Internet

Well, the equation is Ax=b and we want so solve for x

There are several ways of entering the data, but this is one way

Code: A=[15+35i 29+1i; 46+13i 62+3i]

b=[0;0]

x=A\b which has the trivial solution x=[0;0] (the ";" means "next row", a space next column.) To input a matrix use APPs then Data/Matrix Editor then New. Then change Data to Matrix. Put in the name such as "AA" in the variable field. Then enter row and column dimensions. Then edit as a spread sheet. Use F6(util) to delete a column or row. To manipulate matrices, exit the matrix application, then go to MATH then Matrix. Notice that J(RowOpps) is available. Good luck and thank you for using FixYa! We would sure appreciate a 4 "thumbs-up" rating for this answer. Happy holidays!

There are several ways of entering the data, but this is one way

Code: A=[15+35i 29+1i; 46+13i 62+3i]

b=[0;0]

x=A\b which has the trivial solution x=[0;0] (the ";" means "next row", a space next column.) To input a matrix use APPs then Data/Matrix Editor then New. Then change Data to Matrix. Put in the name such as "AA" in the variable field. Then enter row and column dimensions. Then edit as a spread sheet. Use F6(util) to delete a column or row. To manipulate matrices, exit the matrix application, then go to MATH then Matrix. Notice that J(RowOpps) is available. Good luck and thank you for using FixYa! We would sure appreciate a 4 "thumbs-up" rating for this answer. Happy holidays!

Dec 05, 2010 | Texas Instruments TI-84 Plus Calculator

are you using mssql then it must be something like this

Select firstname + ' ' + 'lastname' as 'name' from tablename order by lastname

Select firstname + ' ' + 'lastname' as 'name' from tablename order by lastname

Sep 26, 2009 | Computers & Internet

Here is one way to do it:

1. In column A enter the name

2. In column B enter their start date in the format day-month-2008 (31-12-2008 for Dec. 31, 2008); if a day is less than 10, put zero in front (03, 04, etc.)

3. In column C put 31-12-2008 (December 31, 2008, the last day of the year)

4. In column D, put C1-B1 and format as a number with 2 places after the period (10.25 for example) if you want to track partial days, other format for no zeroes after the period (13)

5. In column E, put this formula:

(D2/30)*1.25 (assuming this is line 2)

You can then copy these lines as many times as you need to, total them, etc.

1. In column A enter the name

2. In column B enter their start date in the format day-month-2008 (31-12-2008 for Dec. 31, 2008); if a day is less than 10, put zero in front (03, 04, etc.)

3. In column C put 31-12-2008 (December 31, 2008, the last day of the year)

4. In column D, put C1-B1 and format as a number with 2 places after the period (10.25 for example) if you want to track partial days, other format for no zeroes after the period (13)

5. In column E, put this formula:

(D2/30)*1.25 (assuming this is line 2)

You can then copy these lines as many times as you need to, total them, etc.

Dec 27, 2008 | Microsoft Office Standard for PC

You probably need to organise your pricelist sheet so that you only have 2 columns, product and price. If this doesn't fix you, please provide the syntax of your vlookup code.

Dec 10, 2008 | Microsoft Excel for PC

Hi,

Try using a software called MacroRunner for Excel v1.0.. you can download this from the following link

http://www.filebuzz.com/fileinfo/21205/MacroRunner_for_Excel.html

Good luck.

Try using a software called MacroRunner for Excel v1.0.. you can download this from the following link

http://www.filebuzz.com/fileinfo/21205/MacroRunner_for_Excel.html

Good luck.

Feb 05, 2008 | Computers & Internet

column d = column c divided by column b. result can be formatted to 3 decimal places or anything you prefer.

Sep 09, 2007 | Microsoft Office Standard for PC

Jan 28, 2016 | Microsoft Excel for PC

Dec 12, 2013 | Microsoft Excel for PC

Jul 23, 2013 | Microsoft Excel for PC

46 people viewed this question

Usually answered in minutes!

Thnx a lot jacco...still having a problem in columns,I have a database that i will import to .csv file and it needs to have at least 800 columns but columns of my excel worksheet is only 250 (estimated) is there a way to make it at least 800 columns?I am new to excell so i can't figure it out I tried help of excell itself but i found no sufficient answer..

×