Questions tagged by "excel"


0
 bounty
0
answers
c# multi-line string value in CSV file for Excel?
5 years ago • allexx@qrid
How to store multi-line string as a field column value in CSV file? Assuming I want to later open this file in MS Excel?
Tags: , ,
0
 bounty
1
answers
Clear Excel DATA but preserve FORMULAS using VBA macro
9 years ago • alex@qrid
How to clear all the data in the current active Excel sheet but keep formula definitions intact? I.e. if I have a table with some columns calculated by formulas, and some other columns containing data loaded from an external SQL database, how do I write a VBA macro that would re-load the data? One of the first steps I would need to do is to clear all the existing data, but preserve all the formula definitions. Looking for a simple code to cle
Tags: , ,
0
 bounty
1
answers
How to clear current Excel worksheet using VBA macro?
9 years ago • alex
What is the simplest VBA code to clear everything in the current active worksheet in Excel?
Tags: , ,
0
 bounty
1
answers
MS Excel - how to create a new line in the formula bar?
9 years ago • alex@qrid
MS Excel - how to create a new line in the formula bar? Is there any keyboard shortkey? I've tried Ctrl+Enter combination but that did not work
Tags:
1 from 4