Search found 19 matches
- Fri Jul 22, 2022 8:58 am
- Forum: PlanMaker 2021 for Windows
- Topic: using the search box or Ctrl + F
- Replies: 3
- Views: 16570
Re: using the search box or Ctrl + F
Thank you - I am pleased to see the responsiveness when little issues are mentioned, that's excellent. In the case of the dialog box - a second and related request. If you work on multiple spreadsheets moving across different tabs, the constant blocking search box can be annoying. Often it's the sam...
- Sat Jul 16, 2022 1:37 am
- Forum: PlanMaker 2021 for Windows
- Topic: vlookup data entry box
- Replies: 11
- Views: 17330
Re: vlookup data entry box
thank you for your help but I am sorry, I watched this clip dozens of time but cannot replicate it. I can copy my original formula across from Excel and it works fine: =VLOOKUP(G2,'VL Inventory'!A:T,20,0) However, when entering it manually using your process I may get the expected #n/a in my sheet b...
- Fri Jul 15, 2022 2:36 pm
- Forum: PlanMaker 2021 for Windows
- Topic: vlookup data entry box
- Replies: 11
- Views: 17330
Re: vlookup data entry box
stascheit - you are right. I have now managed to get this "saved". I still do not understand why if I then enter the formula into the Formula box, I need to know all the info by heart. I do know (and can see) which is the Crit and remember n and O but the range is not on the same sheet and...
- Wed Jul 13, 2022 5:48 am
- Forum: PlanMaker 2021 for Windows
- Topic: vlookup data entry box
- Replies: 11
- Views: 17330
Re: vlookup data entry box
Supertech, thank you - one follow up - is there any reason why vlookup does not show up as my last used function. No matter how often I use it,
under last used I only have Sum and Count (don't know if I ever used count) but vloolup is "hiding" under All Functions at the bottom.
under last used I only have Sum and Count (don't know if I ever used count) but vloolup is "hiding" under All Functions at the bottom.
- Sat Jul 09, 2022 1:17 am
- Forum: PlanMaker 2021 for Windows
- Topic: vlookup data entry box
- Replies: 11
- Views: 17330
vlookup data entry box
I am using vlookup and miss the data entry box that would guide me through the fields in excel. I can manually type in the formula by opening excel, trying to refresh my memory about the correct syntax and then do this in planmaker. Is there a setting I can enable to get such a box that puts the com...
- Fri Jul 08, 2022 1:51 pm
- Forum: PlanMaker 2021 for Windows
- Topic: using the search box or Ctrl + F
- Replies: 3
- Views: 16570
using the search box or Ctrl + F
Having only recently moved to softmaker, I am still finding some features working differently from what I was used to. I don't know if this is due to the implementation in the software or my approach. When using the search function in a spreadsheet I can find the cell or value I am looking for. Howe...
- Wed Jul 06, 2022 2:06 am
- Forum: PlanMaker 2021 for Windows
- Topic: A couple of simple questions
- Replies: 8
- Views: 11768
Re: A couple of simple questions
With respect to the deletion of rows below or to the right of the active part, I think the op refers to a function in excel that may or may not work in planmaker. I only recently started using planmaker, so I am a newbie here: In excel if I have a large spreadsheet and want to go to the end of the s...
- Mon Jun 20, 2022 6:25 am
- Forum: FreeOffice 2021 for Windows (General)
- Topic: Copy and paste using the enter key
- Replies: 3
- Views: 7892
Re: Copy and paste using the enter key
Ctrl + V is fine and I use it often but sometimes just hitting enter is simple
- Mon Jun 20, 2022 5:48 am
- Forum: FreeOffice PlanMaker 2021 for Windows
- Topic: using Filter with drop down
- Replies: 1
- Views: 7052
using Filter with drop down
I have a large spreadsheet which has grown over time and I often use the filter to drill down on information I need, e.g. see records of a certain type. I just noticed that in softmaker using the drop down arrow I have some criteria appearing twice. I carefully looked at these to see if I may have m...
- Mon Jun 20, 2022 5:32 am
- Forum: FreeOffice PlanMaker 2021 for Windows
- Topic: setting print area and/or amending
- Replies: 5
- Views: 10274
Re: setting print area and/or amending
many thanks
- Sat Jun 11, 2022 10:32 am
- Forum: FreeOffice 2021 for Windows (General)
- Topic: Bak file
- Replies: 7
- Views: 12498
Re: Bak file
excellent - thank you for that clarification
- Sat Jun 11, 2022 10:29 am
- Forum: FreeOffice PlanMaker 2021 for Windows
- Topic: setting print area and/or amending
- Replies: 5
- Views: 10274
Re: setting print area and/or amending
Thank you Stascheit - it's a bit clumsy but I can make it work.
Is there any comparison as to which features are available in paid compared to free? I had a look on the site and found some overall
info but something specific like this was not mentioned.
Is there any comparison as to which features are available in paid compared to free? I had a look on the site and found some overall
info but something specific like this was not mentioned.
- Mon Jun 06, 2022 3:28 am
- Forum: FreeOffice PlanMaker 2021 for Windows
- Topic: setting print area and/or amending
- Replies: 5
- Views: 10274
setting print area and/or amending
I am having some issues with the process of printing the correct area in a spreadsheet. I have a file and the print-area has the bulk on page 1 with one column on page 2. I found a setting for Define Print Area but this does not change the print-outcome. Clicking on print preview it appears my setti...
- Fri Jun 03, 2022 12:37 am
- Forum: FreeOffice 2021 for Windows (General)
- Topic: Bak file
- Replies: 7
- Views: 12498
Re: Bak file
Supertech, thank you and I have read this carefully now. I am still a bit unclear as to the difference between clicking the save button in the ribbon while working on a document, relying on the setting Auto Recovery : save state every X minutes and the bak file? It seems to me that in the paid versi...
- Wed Jun 01, 2022 6:38 am
- Forum: FreeOffice 2021 for Windows (General)
- Topic: Copy and paste using the enter key
- Replies: 3
- Views: 7892
Copy and paste using the enter key
I noticed that in order to paste something I actually need to click the past button or right-click paste. Is there any setting I can change to also
accept the enter button for pasting?
accept the enter button for pasting?