![](/rp/kFAqShRrnkQMbH6NYLBYoJ3lq9s.png)
Creating a blank worksheet (with no lines) - MrExcel
May 31, 2007 · I have seen worksheets where all of the lines are removed and it almost has the look of a blank piece of paper. I would like to have a worksheet where I could have a title, a logo, some command buttons for userforms and possibly reports and also be able to change the color and look of the...
copy cell data to other worksheet cell, leave blank if no not
Mar 27, 2009 · Hi, I am wanting to have certain cells of data from one worksheet appear on another worksheet once the cells on the first sheet have data entered in them. I find that I can do a simple formula to copy the cell but I want the cell to remain blank until data is …
Empty rows at top of excel spreadsheet | MrExcel Message Board
Aug 21, 2020 · When clicking on the small top left hand side rectangle to copy an excel spreadsheet, when the copy is pasted to a blank excel spreadsheet several empty rows appear at the top. How do I prevent this happening, how can I delete the automatically generated empty rows at the top of the spreadsheet ?
How to make the spreadsheet blank - MrExcel
Mar 16, 2021 · Hello, I wanna know how one can make the spread sheet blank with no lines and also changing the colour of the background
How to create a blank worksheet if excel is using template
Apr 20, 2022 · This template is completely blank, and you should call it something like blank.xltx. To insert a blank sheet instead of your default sheet, right-click on a sheet tab, select Insert..., then select the blank template from the dialog.
Excel spreadsheet comes up blank after saving...?
Apr 6, 2005 · After saving a fairly large spreadsheet (saved on a shared drive), the next time anyone opens the spreadsheet, it comes up blank. We have had this file restored a few times and the same thing happens.
How to make a cell truly BLANK - MrExcel
Jun 22, 2004 · An Excel formula always returns something (text, number, logical value...) and; therefore, cannot produce an empty cell.
Creating a csv file and showing commas for blank cells - MrExcel
Apr 7, 2002 · I am creating a csv file in a macro. There are 12 columns in total but the last 5 columns are blank. The thing is when the file is opened in notepad format the commas should still appear even though in Excel the cells are empty. E.g. this is how a row of entries should appear if opened in notepad 1,12121,4564,5000,55,094500,T,,,,,
Excel opens 2 worksheets, 1 blank, when I open any spreadsheet
Dec 11, 2014 · MS Windows 7, Office 13 Every time I open a current Excel spreadsheet, another instance of Excel opens. Not another sheet but Excel with the menu tool bars. It happens with any saved spreadsheet I open. It also happens only when I first boot up …
Pasting Problem, pastes blank | MrExcel Message Board
Mar 18, 2010 · I was working in two instances of Excel, copying and pasting, no problems. Then all of a sudden it started pasting blank cells. Here is the rub, if you open a new WB (Ctrl+N) in the destination instance of Excel and try to paste the data there, it …