Questions tagged [cells]
A cell is generally a reference to one point of data in a spreadsheet program. Every data point is within a cell and cells are then grouped into rows, columns or even ranges.
222
questions
0
votes
0
answers
7
views
I want to restrict the input into a range of cells in a spreadsheet to a capital Y without using a data validation list
Using a data validation list would take input longer as there is only one choice. I've seen this formula, but it doesn't seem to work.
=COUNT(MATCH(MID(D2,ROW(INDIRECT("1:"&LEN(D2))),1),...
- 1
0
votes
1
answer
97
views
In Excel, how to show linked cell in the first row
I have a Table of contents pointing to different cells (link example =sheet1!video) in the workbook. Each worksheet has some 500 rows of information
When the link is selected, it goes to correct cell, ...
- 1
0
votes
0
answers
20
views
typing in a number to a cell (say 5) to then merge those 5 cells
Merging multiple lines if one range selected
I have created a small hotel template for reservations
I have created dates and a range of selections
How or what formula, if any, can I use to
when I ...
0
votes
0
answers
21
views
Remove contents of cell in Word table, shift components behind it to fill empty cell?
I am searching for a similar solution to the one posted here in which I have a word document with a succession of cells (images with captions in the cells) arranged in an order. The solution on that ...
- 1
0
votes
1
answer
80
views
Styles based on Normal display a white background, unrelated to the Borders & Shading
In Word, when I write text in a table cell with a colored background, I see a white background behind my text. I supposed it had something to do with the Border & Shading options, but it was ...
-2
votes
1
answer
70
views
In Cell O6 I am checking to see if cell A6 is a public holiday, is so then place a "1" in cell O6, else "2". However cell Q6 will not calculate
In Cell 06 I am checking to see if cell A6 is a public holiday, is so then place a "1" in cell O6, else "2". However cell Q6 will not calculate.
For some reason it will not see the ...
- 1
0
votes
0
answers
99
views
Merge cells in excel depending on the value in another cell
I'm looking to minimize the time required to input information in an Excel worksheet. I have a cell which can have the numbers 1, 2 OR 3 and depending on the value of that cell, I need some cells to ...
- 1
0
votes
1
answer
82
views
How to limit the number of characters per line in a cell in excel 2016
I am trying to combine multiple cells into one, however when combining, I can only have 55 characters per line. Is there a way to create a word wrap that will keep my data to 55 characters per line?
0
votes
2
answers
73
views
Copying Sheets and cell references
Let's say I have "Sheet A" and "Sheet B" within the same workbook.
Sheet B has a cell that references Sheet "A" i.e. ='Sheet A '!Q20
I want to copy Sheet B and Create &...
0
votes
1
answer
32
views
How inserting cells in a row or a column different from inserting row(s) or column(s) between rows and columns?
How is this Inserting cells in a column different from Inserting a column between two columns
P.S.: It's a curious question, and didn't find anything on the internet; hence, I don't add any ...
user1806663
0
votes
0
answers
18
views
Highlight range when press another cell
If countif example "done" range example from A1:A10 and result appear in cell B1
If result =4 .
I want when click B1 .. the cells in range that contain "done" highlight and color
0
votes
2
answers
132
views
In Excel, Format a Number with Intermediate Spacing AND Optional Decimal
I have a series of numbers in Excel that I would like formatted in a certain way and I need some help.
Background:
I work in construction, and am using the Construction Specification Institute's (CSI) ...
- 1
0
votes
1
answer
116
views
Conditional Formatting Not working (maybe pilot error?)
Excel Version 16.68.
I want to compare numbers in Column D to a Reference Number and use Conditional Formatting Formulas in Column E to highlight the corresponding cells.
I use Formulas because the ...
- 1
0
votes
2
answers
407
views
Excel move into data table with enter key only
I need to enter data into Excel using a bar code scanner which add a "enter" key press at the end of the scanned code. I need to scan two codes on a device and link them in a database. ...
- 123
0
votes
1
answer
26
views
Spreadsheet doesn't open on the cell active during save
No matter what cell is active when I save this one particular worksheet, it always opens on cell N124. Other worksheets work fine, they open on the cell that was active when I saved them. Any ...
0
votes
1
answer
125
views
Excel Conditional Formatting - Using Formula as Part of a Cell Reference
I am trying to use conditional formatting to highlight a cell if it is blank and a cell in the first column of the same row is not blank. For example, if the conditional formatting is for cell D4, I ...
- 1
0
votes
1
answer
120
views
How to decrease the number of cells that are selected in the formula in Excel?
I'm using the AVERAGE function and drag/expand it along one row (e.g. from A1 to D1), the cells that are selected should decrease by 1 row in each new column.
For example:
A1
=AVERAGE(A2:A10)
B1
=...
- 1
0
votes
2
answers
1k
views
the arabic content in the cell excel is not shown correctly
The Text is in the cell is well written and when you click on it is is correct as shown in the upper view,
On the cell itself it is not shown correctly
For an example:
Cell view: حمدا
upper view : ...
0
votes
0
answers
171
views
Excell Cell Drop Down Menu randomly lose data when attaching to an email or uploading to Google docs. How to fix?
My employer uses an excel spreadsheet with drop-down menus in some of the cells to keep track of student attendance. When I send the doc via email and upload the doc via Google Drive, sometimes a ...
0
votes
0
answers
30
views
How do I use the information in a cell as the name of the sheet where an index formula is looking up the information from?
Ok I am creating a tracker of information and need to quickly copy and paste formulas since the criteria will be the same but the sheet as to which to look for the results will be different.
in cell ...
0
votes
1
answer
258
views
Excel - Selecting Random Cell followed by Filling
I am trying to select a random cell from an array AND then fill down, fixing the column but letting the row remain relative. For example, I am trying to select the contents of a random cell from A1:...
- 3
0
votes
4
answers
44k
views
Why does Excel add leading apostrophes to some of my text cells?
I have a worksheet containing, among other things, a table object. All data in the worksheet was added by me manually, including the data and column headers in the table.
I just noticed that in 13 of ...
- 3
0
votes
2
answers
8k
views
Use Excel cell value in body of mailto hyperlink
In excel I have some cells that contain input for a e-mail form.
A
B
E-mail
[email protected]
Subject
Input form
Name
John
Country
Poland
Body
Hello,%0D%0A My name is : B3 %0D%0A I'm from : B4
...
- 5
-1
votes
2
answers
224
views
I need software to help know the number cells present in my battery [closed]
Is there any software I can use to get a comprehensive information about my battery ie the number of cells because I read somewhere that the more cells the battery has the longer the charge lasts, I ...
- 261
13
votes
6
answers
11k
views
Prevent Excel to automatically "Wrap text" in a cell
Let's say we have a spreadsheet with all rows having the same default height.
In a cell, let's write Hello ALT+ENTER World. I indeed sometimes need to enter multi-line text in a cell, to write some ...
- 1,804
0
votes
0
answers
26
views
Disable Excel link cell follow click [duplicate]
This is probably the worst design choice I've seen in my life, and it drives me mad.
I need to edit some excel spreadsheets which contain links and move some cells around, and each time I click on a ...
- 101
0
votes
1
answer
311
views
A Function That Is Self-Aware of Its Own Cell Address?
I would like to write a function that is self-aware of its own cell address. For instance, I would like to be able to place an argumentless function in any cell, and when called, that function will ...
- 1
0
votes
5
answers
2k
views
Excel: Sum all numbers separated by new line within cell
How do I create a new cell that equals the sum all numbers in a cell separated by a new line?
I may not use text to columns as that is messy and there's no new line separator delimiter in text to ...
user1214031
0
votes
0
answers
160
views
If cell in one column matches cell in another then copy data
I've got two separate sheets with a few hundred rows of data. I'm trying to see if any cell in Column C (Sheet 1) matches with a cell in column A (Sheet 2) then copy over the adjacent cell in column ...
- 1
0
votes
4
answers
2k
views
excel formula of sum with error and cells not in range
I want a sum formula that will ignore errors.
For example something like: =sum(c3+f3+h3+j3+n3) however, some of these cells may contain an error.
Between these cells there is data which I do not want ...
1
vote
1
answer
830
views
Copy sheet with protected cell
I have an excel worksheet that I protected certain cells with a password. AM afraid it could be touched by another person. How would it be done to COPY A SHEET TO A NEW FILE AND RETAIN THE PROTECTED ...
- 11
2
votes
2
answers
3k
views
In Excel, how can I round or display numbers to 2 significant figures (the two leading non-zero digits of a decimal number)?
In Excel 2016 I need to show zeros out to the leading non-zero digits and then just the two digits after that. For example:
0.00002423 should read 0.000024,
0.242 should read 0.24,
0.0032255 ...
0
votes
0
answers
19
views
Refilling cells without exceeding a certain amount, by a given percentage
I am sorry if this question might sound quite complicated, I will try to be the more clear possible.
I need that the amount in H13 (18,70€ in this case, if positive of course) refill the negative ...
- 1
0
votes
1
answer
218
views
Get cells from another sheet based on criteria
I'm trying to build a simple helper to control my expenses.
One sheet has a list of all financial movements (income and payments), with these details:
Date
Amount
Reason
02/02/21
-1000.00
Rent
02/...
- 295
0
votes
1
answer
720
views
Excel - Use Formula In Different Cell From Referencing In If Statement
I am currently working on a listing template that uses different things like a title generator. This generator uses a ton of if statements based on the data that it is given. I have broken this ...
- 1
0
votes
1
answer
184
views
Display (or get at least) certain cell last modification date in Excel 2003 file (file extension is *.xls)
I have some Excel table which I filled with values since 2004.
To sad I didn't include each row add date in extra cell. Now I want to know that...
Maybe it still possible? Maybe *.xls file store that ...
- 205
1
vote
3
answers
553
views
Inserting a cell in Word table, that shifts the last cell onto the next row ... Can it be done?
I have a Word document in which I have a succession of cells, arranged in alphabetical order reading across. It is six cells wide by however long it goes down.
What I want to be able to do, is add ...
- 11
1
vote
0
answers
12
views
Need help formatting dates and text in a range of cell
I've got a spreadsheet with certificates that expire at different dates. All of these have two columns. In one column is the date the certificate expires in which is usually every 3-5 years. The next ...
- 11
1
vote
0
answers
74
views
i would like to add data from one document into other cell on a daily basis, is this possible?
i want to import data from this sheet into another.
where i can add the number of time 'cardboard' appears in the column 'stillage reference' in column D based on the date in column G on a daily basis....
- 11
0
votes
1
answer
4k
views
I want to add a text in a cell if a number is below or above a value
emphasized text
i want to add the text 'FULL Delivery'' or ''Not Full'' to a cell that is either below 48 or equal to 48.
can anyone help me.
- 11
0
votes
0
answers
864
views
Excel: Fake Blank Cell (cell has no content, nothing in the function box, but not recognized as a blank cell)
I have an Excel file with plenty of "blank" cells, these cells are not showing any content in the cell itself nor in the function box. And I'm trying to replace all these "blank" ...
- 11
0
votes
3
answers
14k
views
How to do hex calculations across multiple cells in excel?
I'm working on a spread sheet and I have a table or grid of [256]x[256] that looks like this:
B c D E F G IY
3 Address: [byte][byte][byte][byte] ... ...
- 131
0
votes
1
answer
56
views
Prevent User to fill in a specified value into a cell before another cell is filled
Since I am not that well versed in Excel I have stumbled upon the following Problem:
I have the two cells:
A1 and B1
I want A1 not to be able to be filled with the value "1" before B2 is ...
- 1
3
votes
2
answers
1k
views
Libre Office - Single Column Pie Chart
I want to create a pie chart, for a single column that looks like this:
I tried to select the range, click on Insert -> Chart -> Pie-Chart, but regardless of what I try, I always get an empty ...
- 127
0
votes
1
answer
82
views
I have cells at the beginning of a spreadsheet that appear blank
I have a spreadsheet that was sent me that has blank columns on cols a-h.
However these are not blank as towards the end of the spreadsheet formulas refer to these.
How do I see the contents of cells ...
- 1
0
votes
4
answers
1k
views
Add a text comment in a numeric cell with Excel
Is there a way with Excel, to put a comment with a numeric cell, like the cell A3 here:
such that formulas like =SUM(A1:A5) still work?
Here the wanted result would be 19.
Here it doesn't work ...
- 1,804
1
vote
0
answers
76
views
How do I turn off autoformat OpenCalc / OpenOffice Spreadsheets
Without context and background: Read the title, How do I turn off AutoCorrect in OpenCalc, specifically time, preferably turn off all AutoFormat.
I am using a spreadsheet to track how fast my online ...
- 11
1
vote
1
answer
799
views
How to shift cells to the left without affecting its "own column" in Excel (i.e. via VBA)?
COLS : NO | | B | C | | D
01 : 1 | | 8 | 3 | | 2
02 : | | | 4 | |
03 : | | | | |
04 : 2 | | 5 | 2 | | 6
How can I shift the values to the left and delete ...
- 11
2
votes
1
answer
1k
views
Two-way connection between multiple cells and across multiple worksheets
I am looking to make a 2-way connection across 2 worksheets so that I only have to change the entry on one sheet for it to be changed on the other and vice versa.
I found a good explanation here (I ...
- 23
0
votes
0
answers
46
views
Removing blank data from cells in Excel
I have a file with 50000 rows and 500 columns approx. with data populated. Though half of the cells in the sheet seem blank but the file looks heavier (50mb) which should not be. When I count the ...
- 53