Explore Spreadsheets on Experts Exchange

Expert Solutions for Your Tech Problems

Spreadsheets

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed...

Read more
  • 7.3K Content
  • 2.0K Contributors

Expert Spotlight
Scott Fell
Developer & Coffee Roaster

I have over 30 years experience in Sales, Marketing, Technology and Developing solutions.

Troubleshooting Solution

How to Save an Advanced Sort in Google Sheets so that you don't need to reenter all sort levels manually

byIP4IT Staff
1

Often we need to do an advanced sort of a spreadsheet in Google sheets.


Each time we need to choose:

…
Troubleshooting Solution

Excel VBA code to copy data from several spreadsheets to a master spreadsheet based on a criteria

bySteve Avery
23

Experts,


I have an Excel VBA question about copying data from 8 spreadsheets into a master

…
Troubleshooting Solution

Umapped values between two Sections of data

byexcel learner
1

Dear experts,

 The purpose of this post is to find there is a possibility to identify the cell to

…
Troubleshooting Solution

Make calls from from a shared spreadsheet using either a phone or a desktop computer

byTed Penner
3

I need an easier way to have someone else make a phone call on my behalf from their desktop by

…
Troubleshooting Solution

Steps to perform Win Explorer search of Excel spreadsheets to display spreadsheets that contain particular number

byIT Guy
2

Within a Windows folder I have around 1800 Excel spreadsheets.


There are too many spreadsheets to

…
Troubleshooting Solution

Google Sheets Cant open this document Update to the Latest Version

byJoseph Salazar
5

Client Using Lenovo Tablets for 3 years using Google sheets


All of a sudden since Monday Nov 6th when

…
Troubleshooting Solution

Using Excel VBA change the encoding of CSV files / data

byTom Crowfoot
4

Hi Experts


I have a piece of excel VBA courtesy of EE which scrolls through all downloaded CSV files

…
Troubleshooting Solution

Convert col/row reference to heading/row reference

byIan Bell
12

I wish to replace the col/row reference with heading/row reference. I have several worksheets using

…
Troubleshooting Solution

Can't save a Notepad document

bynickg5
2

I have text created using Notepad. When I click the "x" top right it wants to save it as *.txt (the

…
Advice Solution

Excel IF function - Multiple criteria

byDeonne Flowers
4

Trying to write formula in Excel. IF function with multiple criteria.


ex: if b7 = travel then

…
Troubleshooting Solution

Modify iframe to produce a better size and hide the title of the sheet

byTed Penner
6

Test this iframe containing a Google Sheet.


I tried to test this iframe in a couple of places and

…
Troubleshooting Solution

Opening Spreadsheets in Teams

bycrp0499
3

I have an issue with Teams not opening excel spreadsheets.

My environment is Windows 2016 domain,

…
Troubleshooting Solution

Formula to calculate maximum number of positive values within an index range.

byIan Bell
3

Number-Values.xlsx

I wish to find number of positive values within an index range.

Please refer to

…
Troubleshooting Solution

How do I convert the hours and minutes values in cell H2 of to a decimal value for cell I2 of a Google spreadsheet

byTed Penner
4

I was surprised that I could not find this information quickly.

I need to convert the hours and

…
Troubleshooting Solution

How to create Google Forms with payment integration

byIP4IT Staff
6

Hi,


We are creating a registration form for a charity using Google Forms.


This form has to have the

…
Troubleshooting Solution

Best front-end for organising and managing online spreadsheets

byIP4IT Staff
2

Hi,


With the advent of cloud computing we find ourselves with hundreds of online spreadsheets; some

…
Troubleshooting Solution

Default programs not working in Windows 10.

bylloving
8

Default programs not working in Windows 10. 

Example: spreadsheets created in Excel will not open

…
Troubleshooting Solution

Bar chart representation in Google Sheets

byTed Penner
1

Bar Charts in Google Sheets


I need assistance developing this bar chart whose type should be 100%

…
Troubleshooting Solution

Google Sheets - Link to specific cell in another sheet in same workbook.

byStephen Kairys
2

Hi,

In a Google Sheet with several tabs (sheets), I have a cell in sheet "Q4". I need to link to cell

…
Troubleshooting Solution

Is there a way to automate filtering in Pivot Table and writing to Google Sheet?

byCoach Bobby Bluford
10

I have a pivot table in Microsoft Excel.  The main parts are Location (Filters), Employees (Rows),

…

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more