•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Replacing blank cells with free version of Excel
Our take
Are you struggling with filling blank cells in the free version of Excel? You're not alone! Many users find this task a bit tricky without access to advanced features. Fortunately, there are straightforward ways to replace those empty cells with "N/A" that don’t require the “GO TO SPECIAL” option. In this guide, we’ll share practical solutions to help you overcome this challenge and enhance your spreadsheet skills. Let’s dive in and turn that frustration into confidence!
Hello everyone!
I just started to learn to use Excel and I'm already stucked with a problem😅
I have to fill in blank cells with the text "N/A" but in the free version of Excel is a bit complicated
I searched on the internet but the main solution is to use the "GO TO SPECIAL" option, which I didn't find on the free version.
For this, I'd like to ask to the community if you may have any solutions or, if you encountered the same problem, how did you solve that?
Thank you! 😊
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Trying to remove invisible characters (go to special -> blanks not finding all blank cells)Hi everyone, I’m at my wits end with this one. I’ve copy and pasted data a large chunk of data from one excel sheet to another that has a blank line or two between meaningful data. I want to remove all those blank cells, but when I use go to special -> blanks it says there isn’t any. I’ve tried using CLEAN, tried using TRIM, tried using both, tried using CODE to detect what character is in the cell, it comes back as #VALUE. The way the data was pulled was with the formula IFERROR(TEXTBEFORE(A1, “ - “,1)””). It isn’t treating “” as blank for whatever reason. Maybe an extra important detail: the original file is a .xls; new book is .xlsx. Using Office 365. Any help is appreciated! submitted by /u/newblood310 [link] [comments]
- How to get rid of blank space in excel dropdownHello, I created a dropdown for data that needs to be filled in on another sheet. Since that data is blank until filled in, the dropdown shows this blank space. I'm not sure if it's red because of my appearance settings or something but I'd like to get rid of this blank part. The "ignore blanks" setting doesn't do anything and like I said, the data needs to be filled in by the user. Thank you https://preview.redd.it/taefuacaaung1.png?width=349&format=png&auto=webp&s=5a12ff2a7a27c3cfb3b6d93ebef08141a47c3184 submitted by /u/Disastrous-Piano-468 [link] [comments]
- Conditional formating an empty cell based off of another cellHello ! I am currently working on a worksheet that has 2 tables for two distinct equations that are used in 2 distinct cases. Case 1 uses Equation 1 that has 9 variables Case 2 uses Equation 2 that has 7 variables In the E column I inserted Text that dictates if I use Equation 1 or Equation 2. The variables for Equation 1 are written on F:N, and the variables for Equation 2 are written on O:U. Now, I want to write a conditional formating for cells that adds "N/A" to the cells that aren't currently in use by the Case in question. So, if for the row 4 I have in the E collumn "Case 1", I want cells F4:N4 to remain blank and to be able to write in manually the data, while cells O4:U4 to have the "N/A" notation since they're not in use. The issue is that excel won't add the "N/A" notation unless something is already written in the cells. I want to make it write "N/A" even when the cell is empty. I use excem 2010. submitted by /u/suffering_addict [link] [comments]
- Change contents of cells based on a drop downSo, I'm trying to generate a spreadsheet to make the forms we use in the office to issue keys. When people are given an apartment, we have a sheet with all the key numbers on it, and then they sign for it. At the moment, we've got 22 different PDFs and Word documents, and it doesn't work. So, what I want to do is this. I've built the template in Excel and created a Reference sheet which will have all the numbers in it. What I am trying to do is set it up so that when you use the Apartment number from a dropdown, it populates with all the key numbers. This sounds like it should be easy to do, but my Excel brain is broken. Advice would be much appreciated! submitted by /u/Hot_Syrup_1774 [link] [comments]