Question about Savy Soda iSpreadsheet Free

Open Question

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 Anonymous on


Add Your Answer

Uploading: 0%


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



Related Questions:

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

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

    1 Answer

    I don't have a sd card but I get damaged sd card notification. What do I Do?

    I believe one of your Drivers in your Device Manager needs to be uninstalled. Here's how this can be accomplished:

    1. Right-click My Computer and select Properties
    2. Click on the Advanced tab
    3. Click on Environment Variables
    4. Below the bottom Environment Variables window pane (System Variables), click on New
    5. For Variable Name, enter devmgr_show_nonpresent_devices
    6. For Variable Value, enter 1
    7. Click OK to close Environment Variables and OK again to close System Properties

    Once you do that, open up the Device Manager, click on View and enable the Show Hidden Devices. Expand the column in the Device Manager which shows your SD Card and if the image icon to the left of the text is grayed out, remove it. You can do this with any other column in the Device Manager too, as long as it's grayed out, it's safe to remove. This is simply the devices your computer has used at some point in time but was left on the computer when you stopped using it.

    Dec 31, 2010 | Computers & Internet

    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

    1 Answer

    About formula

    One way of finding (and removing) duplicate entries is to sort the column and put a simple formulate in a temporary column next to that column; for example - if column A has duplicates, insert a column (B) and starting in B2 put if(A2=A1,"DUP",""). Select B2 and scroll down to the bottom of your spreadsheet. Press <ctrl>-D to extend the formula in B2. Wherever there is a duplicate you'll see "DUP" in column B. If you want to remove the duplicates copy column B and Edit / Paste Special... with "values" selected (to wipe out the formula). You can then sort the spreadsheet on column B and remove rows with DUP in column B.

    If you can't delete the duplicate rows and the order is important first include a column that captures the order - same trick except put row() in that column, copy / paste special the values and then you can re-sort after doing the above to have both the DUPs marked and the original order.

    Hope that helps.

    Aug 08, 2008 | Microsoft Computers & Internet

    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:

    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:

    150 people viewed this question

    Ask a Question

    Usually answered in minutes!

    Top Savy Soda Apps Experts


    Level 3 Expert

    77947 Answers


    Level 3 Expert

    102366 Answers

    ray gallant

    Level 3 Expert

    49215 Answers

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

    Answer questions

    Manuals & User Guides