Question about Savy Soda iSpreadsheet Free

1 Answer

Add information to grayed columns

I had emailed an issue yesterday about the grayed out columns in the spreadsheet (column J on) and received a response that it sounds like my spreadsheet is locked. It is not locked because I can modify all cells except the grayed out ones. How can I add information to the grayed boxes? I see the add column icon at the bottom of the screen, but using that eliminates information already in the existing columns, rather than adding a new column. The details on this product said you have at least 26 columns which I don't have.

Posted by on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Top Expert:

    An expert who has finished #1 on the weekly Top 10 Fixya Experts Leaderboard.

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

  • Master
  • 40,775 Answers

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

Posted on May 11, 2017

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

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

How to add comma in spreadsheet? thanks


To add commas to your spreadsheet you need the format the numbers. If you want your whole spreadsheet to use commas, click on the area to the left of column A and above number 1. This should highlight the whole spreadsheet. Click on the "," icon in the "number" area, and your spreadsheet will be formatted to put commas in.

Good luck,

Paul

May 06, 2016 | Casio Office Equipment & Supplies

1 Answer

I have a column containing a value of a single letter. I need the spreadsheet to sort add rows by letter.


Move the column to A. Mark entire sheet and sort ascending. There are more raffined ways to do this, but this is an easy quick fix...

Sep 07, 2014 | Microsoft Excel for PC

1 Answer

Add columns


Julie, It sounds like the spreadsheet might be locked.

Jan 02, 2014 | Soda iSpreadsheet

2 Answers

How to make a 7 row and a 7 coloum in a spreadsheet


Creating a table in Microsoft Excel 2007 allows you to work with that data independently of the rest of the worksheet. First you must define your table, though, which you can do either from scratch or from data already in the worksheet. The process is a simple one. Read on to learn how to define a table in Excel 2007
  • Start off by doing one of the following: Select the range of cells that you want to make into a table within your worksheet then proceed to Step 2 OR Start immediately with Step 2.

  • Click on the "Insert" tab at the top of the document.

  • Find the "Tables" group, then click on "Table." The "Create Table" dialog box will appear.

  • Type in a range for your table if you did not select a range in Step 1. If you did already select a range then that range will automatically appear in the dialog box.

  • Check the "My Table Has Headers" box if the data set you selected already contains the headers you want to use. If you don't check this box, the table will display default header names, which you can then go in and change.

  • Hit the "OK" button at the bottom of the Create Table dialog box to create your table.

  • Thanks for choosing Fixya............ Sandeep

    Mar 18, 2011 | Computers & Internet

    2 Answers

    VLookup?


    select all columns
    clik on data click filter select autofilter

    Jul 13, 2009 | Microsoft Excel for PC

    1 Answer

    Autofilter ceases to work on large Excel 2003 spreadsheet


    Sounds like there is a gap between the filter heading and the column data. That's the only time I've seen suggested data missing from the drop-down.

    Jun 16, 2009 | Microsoft Computers & Internet

    2 Answers

    Help


    go to page setup and under scaling you can adjust to your required percentage

    Jul 22, 2008 | Microsoft Excel for PC

    1 Answer

    Average handle time


    I have created a spreadsheet for you to a) use and b) to learn from.

    It is an Automated spreadsheet (as they should be) which calculates the number of minutes in a working week or month and calculates the average time per email giving Daily, Weekly and Monthly Outputs. It takes into account Public Holidays (or for time off). You can use the Output to create Graphs etc to visually display the Output.

    It also allows you to calculate a Part Month average.

    I have displayed it as it was CONSTRUCTED and as it would be USED.

    The As Used worksheet is Protected and the only Inputs that can be done are in the Green Boxes (also the Saturday and Sunday boxes but you will need to Unhide the Validation List to include these and then to add 2 more columns titled Is Saturday? and Is Sunday? with the appropriate If Statement.

    To unprotect the sheet go to Tools - Protection - Unprotect. There is no password so leave this blank.

    All the workings are still there, the columns are just Hidden. To Unhide them, highlight the columns to the left and right of the hidden columns, click on Format - Columns - Unhide. To hide them again, highlight the columns that you want hidden, click on Format - Columns - Hide.

    The LOGIC used (as in Functions) may seem complex but if you read the Descriptions in the first row you should be able to work out what and why it was done that way. Click on a cell to see what Function was used where.

    You said that your spreadsheet was becoming a real mess, well I have created a monster for you (but not a mess).

    I have uploaded the file to here:

    http://users.tpg.com.au/lesliecl/

    Hope this gives you the push to really start using Excel.

    Apr 04, 2008 | Microsoft Excel for PC

    Not finding what you are looking for?
    Savy Soda iSpreadsheet Free Logo

    Related Topics:

    147 people viewed this question

    Ask a Question

    Usually answered in minutes!

    Top Savy Soda Apps Experts

    kakima

    Level 3 Expert

    102366 Answers

    Bill Boyd

    Level 3 Expert

    40775 Answers

    shuyumeng
    shuyumeng

    Level 3 Expert

    951 Answers

    Are you a Savy Soda App Expert? Answer questions, earn points and help others

    Answer questions

    Manuals & User Guides

    Loading...