Question about Microsoft Excel for PC

2 Answers

Problem with columns

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....

Posted by on

  • cocskie Jan 28, 2008

    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..

×

Ad

2 Answers

  • Level 1:

    An expert who has achieved level 1.

    MVP:

    An expert that gotĀ 5 achievements.

    Greenhorn:

    A rookie expert who has answered 20 questions on their first day.

    Night Owl:

    An expert who has answered 10 or more questions between 12 midnight and 6am on the same day.

  • Contributor
  • 52 Answers

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
  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that hasĀ over 10 points.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 8 Answers

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

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

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

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

I am renovating and need some kind of account sheet to keep a track on what I am spending.


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

1 Answer

How do I check that I have copied the formula to a new cell?


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".

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

1 Answer

Add information to grayed columns


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

May 11, 2017 | Savy Soda iSpreadsheet Free

1 Answer

Create a program that will the salary, no of hours work, the deduction, total deduction and net pay.


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.

Mar 24, 2011 | Computers & Internet

1 Answer

Solve a matrix of complex numbers using ti89 or any other ti calculator


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!

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

2 Answers

Sorting a single column with both first name and last name


are you using mssql then it must be something like this

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

Sep 26, 2009 | Computers & Internet

1 Answer

Creating vacation accrual spreadsheet


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.

Dec 27, 2008 | Microsoft Office Standard for PC

1 Answer

Need to use the VLOOKUP formula for more then one column


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

1 Answer

Excel Formulas


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.

Feb 05, 2008 | Computers & Internet

2 Answers

Formula for percentages


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

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

Related Topics:

46 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2983 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...