Excel Question
in [Matlab]
|
Prev: using set_param for newly sized individual parameters in lookup tables
Next: full labeling (top bottom left right) of x and y axes
From: Maxx Chatsko on 3 Aug 2010 11:17 Hello all, This really isn't a Matlab question, so I'm sure Walter Roberson will have a good punch line for this post. When in Excel, you can lock cells based on a selection. Once cells are locked however, the sort function becomes unavailable. Does anyone know of a way around this? I have two header rows at the top of my spreadsheet, but when I sort the whole sheet by using Select All, these rows are organized in the mix as well (obviously). There are too many rows to not use Select All and be efficient. Thanks for your feedback. Maxx
From: Andy on 3 Aug 2010 11:25 "Maxx Chatsko" <chatskom(a)chemimage.com> wrote in message <i39btg$mb9$1(a)fred.mathworks.com>... > Hello all, > This really isn't a Matlab question, so I'm sure Walter Roberson will have a good punch line for this post. When in Excel, you can lock cells based on a selection. Once cells are locked however, the sort function becomes unavailable. Does anyone know of a way around this? > I have two header rows at the top of my spreadsheet, but when I sort the whole sheet by using Select All, these rows are organized in the mix as well (obviously). There are too many rows to not use Select All and be efficient. Thanks for your feedback. > Maxx I don't quite understand what you're asking. Are you accessing Excel using actxserver, and trying to use the Excel sort from MATLAB? Are you doing this entirely in Excel? What are you trying to do? Which cells are you locking? Could you provide a small sample of your input/output?
From: Maxx Chatsko on 3 Aug 2010 11:41 "Andy " <myfakeemailaddress(a)gmail.com> Simply an Excel question. No Matlab involved. I figured out a way around the lock cells actually, by putting a ~ in front of the column headers. Sort A-Z puts characters and blanks ahead of numerics and letters. So this works for now. Maxx Thanks for your feedback
From: Steven_Lord on 3 Aug 2010 12:58
"Maxx Chatsko" <chatskom(a)chemimage.com> wrote in message news:i39btg$mb9$1(a)fred.mathworks.com... > Hello all, > This really isn't a Matlab question, so I'm sure Walter Roberson will > have a good punch line for this post. *snip* If you have a question about Excel that's not related in any way to MATLAB, you should probably ask on an Excel-specific newsgroup. Google Groups (http://groups.google.com) suggests microsoft.public.excel as one such newsgroup -- you can access it via Google Groups if your news server doesn't carry it. -- Steve Lord slord(a)mathworks.com comp.soft-sys.matlab (CSSM) FAQ: http://matlabwiki.mathworks.com/MATLAB_FAQ To contact Technical Support use the Contact Us link on http://www.mathworks.com |