Nov 15, 2011 · I have a Excel 2007 workbook that has a SQL query returning 6 fields from a table. I need to delete Row 1 containing the field names so the workbook contains only data. …

Jun 28, 2021 · If there is a space or colon tab or space colon space, the macro put all this text into column 1 which is incorrect. I'm looking for the macro to replace the space with a tab and also …

Jun 23, 2014 · When right clicking on the sheet tab, I need to know if it is possible to remove the "Delete" from being an option. My workbook is structured to where if a single sheet is deleted, …

Feb 26, 2018 · I have Excel 2010 on Windows 7. I have a huge spreadsheet with 55,000 lines so I'm looking to remove all hidden tabs in each spreadsheet in one step. So the clean () function …

Jun 20, 2018 · Hi, all, I downloaded an Excel template from Microsoft called "billing statement of account" and want to modify it. It has helpful prompts like "Enter Company Name in this cell." …

Oct 11, 2023 · Using Excel 2021 Pro, but I think this problem is common to many versions. I have a workbook with four sheets, created years ago. Each sheet has different formatting. Two of …

May 10, 2017 · The way I delete a tab is by putting my cursor right after the tab and then pressing the delete button marked 'delete'. I obviously wait for the blinking line to appear. I can delete a …

Jun 1, 2024 · Office 2021: No "delete" option for an object inserted in the Word file In the screenshot provided (with the attached docx file), the marked object does not have a delete …

Mar 19, 2025 · I assume the problem is that you can not delete the “P:Outlook.pst” file because Outlook has it open? If so, does this apply to your situation? Remove (close) an Outlook Data …

May 2, 2021 · Between the "MESSAGE:" and the What is a tab character, but I would like to replace that tab character with two spaces. This is the macro I found to find the paragraph that …